I tried to restore database to 8.2.3 and 8.3 servers from pgAdmin After restore triggers do not fire.
PgAdmin shows that trigger is attached to dok table: CREATE TRIGGER dok_btrig BEFORE INSERT ON firma1.dok FOR EACH ROW EXECUTE PROCEDURE firma1.dok_seq_trig(); select reltriggers from pg_catalog.pg_class WHERE relname='dok'; returns 64 I added raise notice commands to firma1.dok_seq_trig trigger. Messages do not appear. So trigger is *not* executed. If I run CREATE TRIGGER dok_btrig1 BEFORE INSERT ON firma1.dok FOR EACH ROW EXECUTE PROCEDURE firma1.dok_seq_trig(); trigger dok_seq_trig is executed. I have lot of tables in database. How to restore database properly so that triggers will run ? Or how to enable all triggers ? Andrus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
