From: | "Andrus" <kobruleht2(at)hot(dot)ee> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Triggers are disabled after restore |
Date: | 2008-03-25 18:35:55 |
Message-ID: | fsbgnd$102s$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Roberts, Jon | 2008-03-25 18:37:37 | Re: select any table |
Previous Message | Thomas Kellerer | 2008-03-25 18:24:28 | Re: PostgreSQL, clusters and load-balance |