Jyoti Seth writes:
> How can I disable and enable constraints in Postgres Version 8.4?
See ALTER TABLE DISABLE TRIGGER. (Fooling with reltriggers has been
deprecated since 8.1.)
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make cha
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
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
