pg_restore with --disable-triggers

Поиск
Список
Период
Сортировка
От ow
Тема pg_restore with --disable-triggers
Дата
Msg-id 20031129110601.34734.qmail@web21402.mail.yahoo.com
обсуждение исходный текст
Ответы Re: pg_restore with --disable-triggers
Список pgsql-hackers
pg 7.4.0

Hi,

From the server log:
Nov 28 16:31:02 srv postgres[2484]: [1076-7] ^I-- Disable triggers
Nov 28 16:31:02 srv postgres[2484]: [1076-8] ^IUPDATE pg_catalog.pg_class SET
reltriggers = 0 WHERE oid = 'test'::pg_catalog.regclass;

If table with the name "test" exists in several schemas, wouldn't the above
update disable triggers on table "test" in ALL schemas? Wwouldn't it also
affect  "test" table in the schema that is NOT being restored in a bad way?

Thanks








__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: cvs head configure broken for --with-krb5 on RH9
Следующее
От: Gavin Sherry
Дата:
Сообщение: Re: gettimeofday() goes backwards on FreeBSD 4.9