Triggers are disabled after restore

["Andrus" <kobruleht2@xxxxxx>]

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general