From: Bruce Momjian <pgman@candle.pha.pa.us>
To: rute solipa <rutes@eselx.ipl.pt>
Cc: pgsql-sql@postgresql.org
Cc: kudo@pingpong.net
Subject: Re: disable constraints
Date: Thu, 6 Mar 2003 20:31:02 -0500 (EST)
Message-ID: <200303070131.h271V2B00700@candle.pha.pa.us> (raw)
In-Reply-To: <5.1.1.6.0.20030226151506.026d0a38@mail.eselx.ipl.pt>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgman@candle.pha.pa.us, rutes@eselx.ipl.pt, kudo@pingpong.net
Subject: Re: disable constraints
In-Reply-To: <200303070131.h271V2B00700@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox