Skip site navigation (1) Skip section navigation (2)

pg_restore with --disable-triggers

From: ow <oneway_111(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_restore with --disable-triggers
Date: 2003-11-29 11:06:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
pg 7.4.0


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?


Do you Yahoo!?
Free Pop-Up Blocker - Get it now


pgsql-hackers by date

Next:From: Gavin SherryDate: 2003-11-29 12:09:41
Subject: Re: gettimeofday() goes backwards on FreeBSD 4.9
Previous:From: Peter EisentrautDate: 2003-11-29 09:59:54
Subject: Re: cvs head configure broken for --with-krb5 on RH9

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group