Triggers are disabled after restore - Mailing list pgsql-general

From Andrus
Subject Triggers are disabled after restore
Date
Msg-id fsbgnd$102s$1@news.hub.org
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: srdjan
Date:
Subject: RULES and QUALIFICATION for INSERT
Next
From: Alan Hodgson
Date:
Subject: Re: select any table