Postgres Pro
Downloads
Home   >   mailing lists

Re: Temparary disable constraint - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Temparary disable constraint
Date
Msg-id 200701170302.l0H32Yn23178@momjian.us
Whole thread Raw
In response to Temparary disable constraint  (Hubert FONGARNAND <informatique.internet@fiducial.fr>)
Responses Re: Temparary disable constraint  (Hubert FONGARNAND <informatique.internet@fiducial.fr>)
List pgsql-hackers
Tree view 
Hubert FONGARNAND wrote:
> Hi,
> 
> Is there a way to temporary disable a constraint (without drop and
> recreating it) in postgresql?

Sure, try ALTER TABLE ... DISABLE TRIGGER for the constraint trigger
name.

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +

pgsql-hackers by date:

Previous
From: "Takayuki Tsunakawa"
Date:
Subject: What is the motivation of include directive and configuration files outside PGDATA
Next
From: Tom Lane
Date:
Subject: Re: Idea for fixing the Windows fsync problem