[HACKERS] pg_restore with --disable-triggers

2003-11-29 Thread ow
pg 7.4.0 Hi, From the server log: Nov 28 16:31:02 srv postgres[2484]: [1076-7] ^I-- Disable triggers Nov 28 16:31:02 srv postgres[2484]: [1076-8] ^IUPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid = 'test'::pg_catalog.regclass; If table with the name test exists in several schemas,

Re: [HACKERS] pg_restore with --disable-triggers

2003-11-29 Thread Tom Lane
ow [EMAIL PROTECTED] writes: Nov 28 16:31:02 srv postgres[2484]: [1076-8] ^IUPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid = 'test'::pg_catalog.regclass; If table with the name test exists in several schemas, wouldn't the above update disable triggers on table test in ALL schemas?