From: Jerry Sievers <gsievers19@comcast.net>
To: Raghavendra <raghavendra.rao@enterprisedb.com>
Cc: Ankur Kaushik <ankurk@trimax.in>, pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Posgres Query for Foreign Key Check
References: <000001d061da$6d0567e0$471037a0$@trimax.in>
 <CA+h6AhiLJ24C=n5juDHdKKD0dj6Yxg92b786TUSQ5NQRHZrvMA@mail.gmail.com>
Date: Thu, 19 Mar 2015 12:45:37 -0500
In-Reply-To: 
 <CA+h6AhiLJ24C=n5juDHdKKD0dj6Yxg92b786TUSQ5NQRHZrvMA@mail.gmail.com>
 (Raghavendra's message of "Thu, 19 Mar 2015 14:50:57 +0530")
Message-ID: <86wq2ckhj2.fsf@jerry.enova.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Raghavendra <raghavendra.rao@enterprisedb.com> writes:

> On Thu, Mar 19, 2015 at 5:49 AM, Ankur Kaushik <ankurk@trimax.in> 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?

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@trimax.in and delete all copies.
>

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


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