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 [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
