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