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 want to execute a sql file for that I need to disable constraints.
In postgres version 8.3, I was executing the script by doing the
following:
1. Disabling triggers by updating “reltriggers” field of pg_class to 0 .
2. Executing sql file
3. Then updating “reltriggers” field of
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
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 thro
