Re: disable trigger all

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: disable trigger all
Дата
Msg-id AANLkTi=d1694b8T2j+yYCmgqHegm2N-9inXq2RY_=oug@mail.gmail.com
обсуждение исходный текст
Ответ на Re: disable trigger all  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
2010/9/29 Tom Lane <tgl@sss.pgh.pa.us>:
> =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman@gmail.com> writes:
>> I got bitten Today by 'alter table disable trigger all' vs 'trigger user'.
>> Basically , assuming that psql doesn't show me that FKs are disabled
>> some code was using 'trigger all' instead of 'user'.
>
> I think that is today's lesson in why not to work as a superuser except
> when you absolutely have to.


Thanks :)
Somehow I knew, you're not going to say. 'Ya, this is a bug, that info
should be displayed to the user'.

--
GJ

В списке pgsql-general по дате отправления:

Предыдущее
От: Adam Wizon
Дата:
Сообщение: Fwd: Restore problem from 8.4 backup to 9.0
Следующее
От: Henri De Feraudy
Дата:
Сообщение: Basic question on PGSQL and Transactions