Re: Need to check disabled constraints

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jan 29, 2018 at 12:19 AM, Sohel Tamboli <sohel.tamboli0016@xxxxxxxxx> wrote:
Hi, 

Any updates? 
Also I need to disable all FK in schema/database for database migration. How can I achieve that? 


​pg_dump/pg_restore handles this for you...but see:

"DISABLE/ENABLE [ REPLICA | ALWAYS ] TRIGGER"


On 25-Jan-2018 12:57 pm, "Sohel Tamboli" <sohel.tamboli0016@xxxxxxxxx> wrote:
Can anyone please let me know how I can check disabled constraints in postgresql 9.1 database. 
I know that ALTER TABLE tablename DISABLE TRIGGER ALL; can disable foriegn constraints, but how I can check if it is really disabled. Similarly I need to check if constraint is enable. 

In oracle we have option to check status of constraint in user_constraints table but do we have same in postgresql as well? 


A doc skim should have led you to pg_triggers in the "System Catalogs" chapter.  The column tgenabled looks like what you are looking for.

David J.


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux