ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > Alvaro Herrera <[EMAIL PROTECTED]> wrote: >> So I gave up waiting for someone else to do the reloptions patch for >> autovacuum and started work on it myself.
> Is it needed to keep backward compatibility? > I'd like to suggest to keep pg_catalog.pg_autovacuum as a system view > even after the options is put into reloptons, and the view to be > updatable using RULEs if possible. Ugh. No. It has been explicitly stated all along that pg_autovacuum was a temporary API and that anyone depending on it could expect future trouble. > But we will not able to do that if the settings will be in reloptions > because ALTER TABLE SET cannot be used with JOINs. Any mechanism that a rule might use to set reloptions would be just as usable in a join as the rule itself ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers