Re: to suspend constraints

From: Jules Alberts <root(at)localhost(dot)localdomain(dot)invalid>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: to suspend constraints
Date: 2003-03-26 07:15:30
Message-ID: slrnb82kgj.dn2.root@systemec.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Jowisz <jowisz(at)USUNTO(dot)rozanka(dot)wroc(dot)pl> Wed, 26 Mar 2003 01:54:59 +0100:
> Hello,
>
> Does anyone knows, is there any possibility to turn off temporarily
> (to suspend) constraints checking? I couldn't find this in docs. Or
> maybe there isn't way to do things like this...
>
> Thanks in advance & greets Adam

Have a look at DEFERRABLE and INITIALLY DEFERRED in the CREATE TABLE
statement.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Hutchinson 2003-03-26 07:32:52 Re: transaction blocking inserts in postgresql 7.3
Previous Message Greg Stark 2003-03-26 06:41:14 Re: Issue with Rowid's during Oracle to Postgres convertion: