Re: disable trigger all - Mailing list pgsql-general

From Tom Lane
Subject Re: disable trigger all
Date
Msg-id 14510.1285770165@sss.pgh.pa.us
Whole thread Raw
In response to disable trigger all  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: disable trigger all  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
=?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.

            regards, tom lane

pgsql-general by date:

Previous
From: Adam Wizon
Date:
Subject: Fwd: Restore problem from 8.4 backup to 9.0
Next
From: Adam Wizon
Date:
Subject: Fwd: Restore problem from 8.4 backup to 9.0