Diabling constraints

From: Linh Luong <linh(dot)luong(at)computalog(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Diabling constraints
Date: 2001-09-14 21:26:46
Message-ID: 3BA27616.D14F6D8D@computalog.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am wondering is there any way of disabling constraints that was
created after the table itself was created.

I know I can drop the trigger that the constraint creates. However, I
need to make this change in several postgres database and it seems like
the the tgname that is required to remove the constraint is generate by
the system so I can't just go
drop trigger "<tgname>" on <tablename> because tgname is different in
all the database I need to modify.

Any ideas in disabling or removing them without harding the tgname..
Thanks

--
LL

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2001-09-14 21:27:50 Re: Case sensitivity issue
Previous Message Patrik Kudo 2001-09-14 21:09:11 Re: get certain # of recs