dbTalk Databases Forums  

Disabling constraints

comp.databases.postgresql.sql comp.databases.postgresql.sql


Discuss Disabling constraints in the comp.databases.postgresql.sql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kumar
 
Posts: n/a

Default Disabling constraints - 02-17-2004 , 11:13 PM






Dear friends,

I am working opn Postgres 7.3.4 on RH Linux 7.2.

I wanted to disable constraints.

Alter table 'table name' disable constraint 'constraint name'; doesn't work.

I got some information from google, which says about indirect way of disabling and enabling a constraint, as follows.
update pg_class set reltriggers=0 where relname = 'crm.activities';
update pg_class set reltriggers = count(*) from pg_trigger where pg_class..oid=tgrelid and relname='crm.activities';

Also doesnt work.

Is there a way to do it?

Thanks
Kumar


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.