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 [EMAIL PROTECTED] 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
