Re: Feature Request: Better handling of foreign keys in DELETE statements

Поиск
Список
Период
Сортировка
От Marti Raudsepp
Тема Re: Feature Request: Better handling of foreign keys in DELETE statements
Дата
Msg-id CABRT9RCezNAxTORS=QgmJLCeHTv1JcA0ysV0rufuNt+Dd24Hwg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Feature Request: Better handling of foreign keys in DELETE statements  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Feature Request: Better handling of foreign keys in DELETE statements
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Patrick Kevin McCaffrey
Дата:
Сообщение: Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
Следующее
От: Rick Pufky
Дата:
Сообщение: Re: recovery_target_timeline and multiple slave behavior when master fails