Re: Posgres Query for Foreign Key Check

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

 



Jerry Sievers <gsievers19@xxxxxxxxxxx> writes:

> Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx> writes:
>
>> On Thu, Mar 19, 2015 at 5:49 AM, Ankur Kaushik <ankurk@xxxxxxxxx> wrote:
>>
>>     Hi ,
>>    
>>      
>>    
>>     We are in Process of migration our Database from Mysql to Postgres .
>>    
>>      
>>    
>>     I want ot know How I can disable foreign key check in posgres just as in MySQL set session foreign_key_checks=0;
>>    
>>      
>>
>> â??Try.â??
>>
>> â??ALTER TABLE table_name DISABLE TRIGGER ALL; 
>
> Yeah but really *good* platforms like MySQL let you totally screw your
> whole DB with just one easy command.
>
> Why can't Postgres suck like that?

Oops!

It can if you subvert session_replication_role :-)  I'll leave doing
the details as a user exercise.

>
> FWIW
>
>
>>
>> http://www.postgresql.org/docs/9.3/static/sql-altertable.html
>>
>> ---
>> Regards,
>> Raghavendra
>> EnterpriseDB Corporation
>> Blog: http://raghavt.blogspot.com/
>>  
>>
>>     Regards
>>    
>>     Ankur
>>    
>>     DBA | Trimax Infrastructure
>>
>>     Disclaimer: This e-mail may contain material that is confidential, privileged and product for the sole use of the intended recipient. Any review, reliance or
>>     distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender or 
>>     legal@xxxxxxxxx and delete all copies.
>>

-- 
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@xxxxxxxxxxx
p: 312.241.7800


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[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