X-Original-To: pgsql-sql@postgresql.org
Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251])
	by postgresql.org (Postfix) with ESMTP id B7EE24763A6
	for <pgsql-sql@postgresql.org>; Thu,  6 Mar 2003 20:31:20 -0500 (EST)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.10.1) id h271V2B00700;
	Thu, 6 Mar 2003 20:31:02 -0500 (EST)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200303070131.h271V2B00700@candle.pha.pa.us>
Subject: Re: disable constraints
In-Reply-To: <5.1.1.6.0.20030226151506.026d0a38@mail.eselx.ipl.pt>
To: rute solipa <rutes@eselx.ipl.pt>
Date: Thu, 6 Mar 2003 20:31:02 -0500 (EST)
Cc: pgsql-sql@postgresql.org, kudo@pingpong.net
X-Mailer: ELM [version 2.4ME+ PL99 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Archive-Number: 200303/172
X-Sequence-Number: 12212


TODO has:

	* Allow triggers to be disabled [trigger]

and referential constraints are implemented using triggers, so no, we
don't have that functionality yet.

---------------------------------------------------------------------------

rute solipa wrote:
> i whant avoid to dropping constraint, i whant to disable the constraints, 
> because i need to insert a large amont of data.
> is there a way?
> 
> best regards,
> rute
> 
> 
> 
> At 03:47 PM 2/26/2003 +0100, you wrote:
> >Hi!
> >
> >use "alter table ??? drop constraint ???"
> >
> >example:
> >
> >create table asdf (userid text, foreign key (userid) references 
> >person(userid) on delete cascade);
> >
> >\d asdf
> >     Table "public.asdf"
> >  Column | Type | Modifiers
> >--------+------+-----------
> >  userid | text |
> >Foreign Key constraints: $1 FOREIGN KEY (userid) REFERENCES person(userid) 
> >ON UPDATE NO ACTION ON DELETE CASCADE
> >
> >alter table asdf drop constraint "$1";
> >
> >Regards,
> >Patrik Kudo
> >
> >rute solipa wrote:
> >>hello,
> >>does anyone nows how can i disable/enable table or column constraints?
> >>in oracle it's possible to disable constraints like this:
> >>alter table tb_1
> >>disable primary key;
> >>best regards,
> >>rute
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 3: if posting/reading through Usenet, please send an appropriate
> >>subscribe-nomail command to majordomo@postgresql.org so that your
> >>message can get through to the mailing list cleanly
> >
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073