Re: [GENERAL] disable trigger all

2010-09-29 Thread Grzegorz Jaśkiewicz
2010/9/29 Tom Lane : > =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= 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 toda

Re: [GENERAL] disable trigger all

2010-09-29 Thread Tom Lane
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= 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

[GENERAL] disable trigger all

2010-09-29 Thread Grzegorz Jaśkiewicz
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'. Is that a bug of psql, or a feature ? As far as I can see pg_catalog.pg_constraint doesn't contain in