Re: replicating DDL statements

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: replicating DDL statements
Дата
Msg-id 20030306173642.Y27304@mail.libertyrms.com
обсуждение исходный текст
Ответ на Re: replicating DDL statements  ("Ed L." <pgsql@bluepolka.net>)
Ответы Re: replicating DDL statements  ("Ed L." <pgsql@bluepolka.net>)
Список pgsql-general
On Thu, Mar 06, 2003 at 02:45:41PM -0700, Ed L. wrote:
> And in the absence of a SET TRIGGERS='off' command, anyone see any concerns
> with the following?
>
>   UPDATE pg_trigger
>   SET tgenabled = 'f'
>   WHERE tgname LIKE '%whatever%';

I have heard warnings that this is not guaranteed to work, as there
may still be places in the code where checking that table is not
happening.  Perhaps that was only true for older versions, though?

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


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

Предыдущее
От: "Thomas T. Thai"
Дата:
Сообщение: Tom Lane - Your email filters are blocking everything
Следующее
От: Tanu Shankar Bhatnagar
Дата:
Сообщение: designer tool for pgsql