Re: pg_restore --disable-triggers does not stop triggers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "CN" <cnliou9(at)fastmail(dot)fm>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_restore --disable-triggers does not stop triggers
Date: 2005-10-07 03:25:46
Message-ID: 28703.1128655546@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"CN" <cnliou9(at)fastmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message suresh ramasamy 2005-10-07 04:14:22 Re: How to uninstall Postgres on Iinux.
Previous Message Tom Lane 2005-10-07 03:15:15 Re: PostgreSQL Gotchas --- count()