Triggers are disabled after restore

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

Browse pgsql-general by date

  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