Re: disable constraints

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(at)postgresql(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073