Re: Coping with huge deferred-trigger lists

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Coping with huge deferred-trigger lists
Date: 2001-05-14 14:45:24
Message-ID: 9222.989851524@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
> The detail I'm wondering about most is how you'd know in an
> UPDATE case which two tuples (one deleted during this XACT
> and one inserted) are the two for OLD and NEW in the call to
> the trigger.

Ugh ... good point. There's no back-link from the updated tuple to
its original on disk, is there?

Back to the drawing board ...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gilles DAROLD 2001-05-14 15:03:18 Re: Re: 7.2 items
Previous Message Tom Lane 2001-05-14 14:41:13 Re: Re: bug in PLPGSQL