Re: plpython triggers TD["new"] = None

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Lee Jensen <ljensen(at)carriersales(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: plpython triggers TD["new"] = None
Date: 2005-01-27 23:01:32
Message-ID: 20050127230132.GA47820@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Jan 27, 2005 at 07:46:54PM -0300, Alvaro Herrera wrote:
> On Thu, Jan 27, 2005 at 03:34:55PM -0700, Michael Fuhr wrote:
>
> > OLD and NEW don't make sense in statement-level triggers because
> > the statement could affect many rows. Use FOR EACH ROW if you need
> > to access the row values.
>
> IMHO they do make sense. It's just that they haven't been implemented.

What do you have in mind? What would OLD and NEW refer to in
statements that affect multiple rows? Are you thinking of a way
to refer to all of the old and new rows?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2005-01-27 23:11:50 Re: plpython triggers TD["new"] = None
Previous Message Alvaro Herrera 2005-01-27 22:46:54 Re: plpython triggers TD["new"] = None