Skip site navigation (1) Skip section navigation (2)

Re: Trigger question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Neil Conway <neilc(at)samurai(dot)com>,Harald Fuchs <hf99(at)protecting(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Trigger question
Date: 2004-01-20 16:02:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Richard Huxton <dev(at)archonet(dot)com> writes:
> On Tuesday 20 January 2004 00:01, Neil Conway wrote:
>> Yeah, I didn't get around to implementing that. If anyone wants this
>> feature, I'd encourage them to step up to the plate -- I'm not sure
>> when I'll get the opportunity/motivation to implement this myself.

> I didn't think they'd be meaningful for a statement-level trigger. Surely 
> OLD/NEW are by definition row-level details.

According to the complainants, OLD/NEW are commonly available as
recordsets (tables) inside a statement trigger.  I'm not very clear on
how that works myself --- in particular, one would think it important to
be able to work with corresponding pairs of OLD and NEW rows, which
would be painful with a table-like abstraction.  Can anyone explain
exactly how it's done in, say, Oracle?

			regards, tom lane

In response to


pgsql-performance by date

Next:From: Harald FuchsDate: 2004-01-20 16:15:31
Subject: Re: Trigger question
Previous:From: Neil ConwayDate: 2004-01-20 15:17:24
Subject: Re: Trigger question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group