Re: Disable and enable of table and column constraints

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Disable and enable of table and column constraints
Дата
Msg-id 20090912120634.GA5285@svana.org
обсуждение исходный текст
Ответ на Re: Disable and enable of table and column constraints  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: Disable and enable of table and column constraints  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
On Thu, Sep 10, 2009 at 04:24:15PM -0400, Jan Wieck wrote:
> The feature was originally intended to be a clean way of avoiding
> interferences of triggers and/or foreign keys with replication systems
> that work on the user level (like Bucardo, Londiste and Slony). The only
> way to break foreign keys in that scenario is to replicate a referencing
> table without replicating the corresponding PK table.

FWIW, I find the ability in Slony to configure triggers so they work or
not depending on the replication role to be extremely useful. Absolutely
a major positive feature.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: COPY enhancements
Следующее
От: Grzegorz Jaskiewicz
Дата:
Сообщение: Re: clang's static checker report.