Le vendredi 18 mars 2011 à 08:20 +0000, Grzegorz Jaśkiewicz a écrit : > There's a generic trigger that sends a signal to a process whenever > changes are made (via listen/notify mechanism), but when FK cascade > fires it will cause a mass amount of notifies to be send out and I > want to avoid it. >
I have no personal experience with this, but citing an answer to a similar question by Vibhor Kumar from a couple days ago : use following command: ALTER TABLE <tablename> DISABLE TRIGGER [ trigger_name | ALL | USER ] -- Vincent Veyron http://marica.fr/ Logiciel de gestion des sinistres pour le service juridique -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general