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

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 (view raw or flat)
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

pgsql-bugs by date

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

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