Alvaro Herrera <alvhe...@2ndquadrant.com> writes: > Tom Lane wrote: >> AFAICT event triggers don't belong to any particular schema, so I'd >> propose that they be dumped only when include_everything is true, >> which is the usual rule for objects that don't belong to any schema. >> >> Transforms have got the same issue, which means that the dump of a >> database containing, eg, hstore_plperl is outright broken: it will >> dump both the extension *and* a CREATE TRANSFORM command. Again, they >> ought to obey the default rules for schema-less objects, which in >> this case is "dump if include_everything and not an extension member".
> Sounds reasonable. (I assume this last detailed rule is what applies to > both object types. Surely event triggers can be part of an extension > too.) Don't know offhand if they can or not, but the code will do the right thing if so. 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