Gordon Shannon escribió: > Ah, now I see what you meant. Forgive me, I thought you were referring to > the pg_autovacuum table in 8.3 where you have to specifiy something for each > column, and -1 says use the default. It appears in 8.4.0 I have to > explicitly set ALL (?) other storage parameters to -1 to get the default, > otherwise I am getting zero for each value?? I don't believe the > documentation mentions this rather important detail: > http://www.postgresql.org/docs/8.4/static/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS. > Did I miss it somewhere?
Err, no, that would be a bug. Please update to 8.4.2, I think we fixed it there. revision 1.28.2.1 date: 2009-08-27 13:19:31 -0400; author: alvherre; state: Exp; lines: +10 -10; Fix handling of autovacuum reloptions. In the original coding, setting a single reloption would cause default values to be used for all the other reloptions. This is a problem particularly for autovacuum reloptions. Itagaki Takahiro -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general