Triggers are disabled after restore

Поиск
Список
Период
Сортировка
От Andrus
Тема Triggers are disabled after restore
Дата
Msg-id fsbgnd$102s$1@news.hub.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: srdjan
Дата:
Сообщение: RULES and QUALIFICATION for INSERT
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: select any table