Re: Index corruption

Поиск
Список
Период
Сортировка
От Marc Munro
Тема Re: Index corruption
Дата
Msg-id 1151618776.3913.62.camel@bloodnok.com
обсуждение исходный текст
Ответ на Re: Index corruption  (Hannu Krosing <hannu@skype.net>)
Список pgsql-hackers
On Fri, 2006-06-30 at 00:37 +0300, Hannu Krosing wrote:
> Marc: do you have triggers on some replicated tables ?
>
We have a non-slony trigger on only 2 tables, neither of them involved
in this transaction.  We certainly have no circular trigger structures.

> I remember having some corruption in a database with weird circular
> trigger structures, some of them being slony log triggers.
>
> The thing that seemed to mess up something inside there, was when change
> on parent rownt fired a trigger that changes child table rows and there
> rows fired another trigger that changed the same parent row again.
>

__
Marc

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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: Index corruption
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Index corruption