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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to