Re: [SQL] Disable Constraints in Postgresql 8.4

2009-09-29 Thread Tom Lane
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

[SQL] Disable Constraints in Postgresql 8.4

2009-09-29 Thread Jyoti Seth
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