Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore --disable-triggers does not stop triggers - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore --disable-triggers does not stop triggers
Date
Msg-id 28703.1128655546@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore --disable-triggers does not stop triggers  ("CN" <cnliou9@fastmail.fm>)
Responses Re: pg_restore --disable-triggers does not stop triggers  ("CN" <cnliou9@fastmail.fm>)
List pgsql-general
Tree view 
"CN" <cnliou9@fastmail.fm> writes:
> I notice that PostgreSQL does disable triggers but it seems to not
> disable CHECK constraint:

Why should it?

(Hint: a check constraint that looks at anything but the row being
checked is broken by definition.)

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL Gotchas --- count()
Next
From: suresh ramasamy
Date:
Subject: Re: How to uninstall Postgres on Iinux.