| From: | Marc Munro <marc(at)bloodnok(dot)com> |
|---|---|
| To: | Hannu Krosing <hannu(at)skype(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: Index corruption |
| Date: | 2006-06-29 22:06:16 |
| Message-ID: | 1151618776.3913.62.camel@bloodnok.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-06-29 23:27:07 | Re: Index corruption |
| Previous Message | Tom Lane | 2006-06-29 22:01:08 | Re: [HACKERS] Non-transactional pg_class, try 2 |