artifact_id;status_id;status_name;priority;submitter_id;submitter_name;assigned_to_id;assigned_to_name;open_date;close_date;last_modified_date;summary;details;"Category";"Group";"Resolution"
1011194;1;"Open";3;462057;"Keyur Govande";100;"Nobody";"2012-05-16 21:14";"";"2012-09-24 02:14";"default_pool_size and reserve_pool_size cannot be configured using ""set"" command ";"The variables default_pool_size and reserve_pool_size cannot be changed using the ""set"" commands. 

The cf_default_pool_size and cf_res_pool_size are appropriately updated, but the settings stored in the DB object (PgDatabase*) aren't updated. So the pool size doesn't really change at all.

The only way to change these 2 variables dynamically is to change the config file and then reload. Reload calls config_postprocess() to update the PgDatabase* objects.";"None";"None";"None"
1011331;1;"Open";3;495006;"Christopher Causer";100;"Nobody";"2013-05-07 14:28";"";"2013-05-07 14:28";"Documentation error for deallocate_all() in FAQ";"Hi,

Not sure if this is the correct forum to post a mistake in the documentation:

http://pgbouncer.projects.pgfoundry.org/doc/faq.html#_cleaning_prepared_statements_on_postgresql_8_2_and_older

Trying to create the function on my postgres 8.1 server gave me:

ERROR:  loop variable of loop over rows must be record or row variable at or near ""LOOP"" at character 210

I was able to create the function as follows:

CREATE OR REPLACE FUNCTION deallocate_all()
  RETURNS void AS $$
  DECLARE
     sql record;
  BEGIN
    FOR sql IN
      SELECT 'deallocate ' || quote_ident(name)
        AS text
      FROM pg_catalog.pg_prepared_statements
    LOOP
      EXECUTE sql.text;
    END LOOP;
  END;
$$ LANGUAGE plpgsql;

";"None";"None";"None"