Postgres Pro
Downloads
Home   >   mailing lists

Re: Feature Request: Better handling of foreign keys in DELETE statements - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: Feature Request: Better handling of foreign keys in DELETE statements
Date
Msg-id CABRT9RCezNAxTORS=QgmJLCeHTv1JcA0ysV0rufuNt+Dd24Hwg@mail.gmail.com
Whole thread Raw
In response to Re: Feature Request: Better handling of foreign keys in DELETE statements  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Feature Request: Better handling of foreign keys in DELETE statements
List pgsql-general
Tree view 
On Mon, Dec 19, 2011 at 18:14, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> you can disable check per session if you need
> ALTER TABLE ... DISABLE TRIGGER ALL;

This is NOT a per-session command, this applies to all connections and
queries, and may allow incorrect data into the table. Don't do this!
(And it doesn't address the question anyway)

Regards,
Marti

pgsql-general by date:

Previous
From: Patrick Kevin McCaffrey
Date:
Subject: Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
Next
From: Rick Pufky
Date:
Subject: Re: recovery_target_timeline and multiple slave behavior when master fails