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 information about whether FK is disabled as a result of trigger disabling query or not. So it is hard to asses the damage as well. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
