From: Jerry Sievers <gsievers19@comcast.net>
To: Jerry Sievers <gsievers19@comcast.net>
Cc: Raghavendra <raghavendra.rao@enterprisedb.com>
Cc: Ankur Kaushik <ankurk@trimax.in>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Posgres Query for Foreign Key Check
Date: Thu, 19 Mar 2015 12:50:23 -0500
Message-ID: <86pp84khb4.fsf@jerry.enova.com> (raw)
In-Reply-To: <86wq2ckhj2.fsf@jerry.enova.com>
References: <000001d061da$6d0567e0$471037a0$@trimax.in>
<CA+h6AhiLJ24C=n5juDHdKKD0dj6Yxg92b786TUSQ5NQRHZrvMA@mail.gmail.com>
<86wq2ckhj2.fsf@jerry.enova.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Jerry Sievers <gsievers19@comcast.net> writes:
> 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?
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@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, raghavendra.rao@enterprisedb.com, ankurk@trimax.in
Subject: Re: Posgres Query for Foreign Key Check
In-Reply-To: <86pp84khb4.fsf@jerry.enova.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox