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, wouldn't the above
update disable triggers on table "test" in ALL schemas? Wwouldn't it also
affect  "test" table in the schema that is NOT being restored in a bad way?

Thanks








__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

Sat, 29 Nov 2003 03:06:01 -0800 (PST)
ow <oneway_111@yahoo.com>
pg_restore with --disable-triggers
ow <oneway_111@yahoo.com> 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?

No.

			regards, tom lane

Sat, 29 Nov 2003 11:47:50 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_restore with --disable-triggers 