Re: Index corruption - Mailing list pgsql-hackers

From Marc Munro
Subject Re: Index corruption
Date
Msg-id 1151618776.3913.62.camel@bloodnok.com
Whole thread Raw
In response to Re: Index corruption  (Hannu Krosing <hannu@skype.net>)
List 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 by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Index corruption
Next
From: Tom Lane
Date:
Subject: Re: Index corruption