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

2005-01-27 Thread Michael Fuhr
On Thu, Jan 27, 2005 at 08:11:50PM -0300, Alvaro Herrera wrote: > On Thu, Jan 27, 2005 at 04:01:32PM -0700, Michael Fuhr wrote: > > > > 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

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

2005-01-27 Thread Alvaro Herrera
On Thu, Jan 27, 2005 at 04:01:32PM -0700, Michael Fuhr wrote: > 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 aff

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

2005-01-27 Thread Michael Fuhr
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 value

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

2005-01-27 Thread Alvaro Herrera
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

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

2005-01-27 Thread Alvaro Herrera
On Thu, Jan 27, 2005 at 03:13:27PM -0700, Lee Jensen wrote: > I have postgres 7.4.6 installed on 2 machines one debian and one > freebsd. Both are the most recent installs of each OS. On both I have > the plpython module and both are having the same issue. Essentially when > a function is called

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

2005-01-27 Thread Michael Fuhr
On Thu, Jan 27, 2005 at 03:13:27PM -0700, Lee Jensen wrote: > I have postgres 7.4.6 installed on 2 machines one debian and one > freebsd. Both are the most recent installs of each OS. On both I have > the plpython module and both are having the same issue. Essentially when > a function is calle

[BUGS] plpython triggers TD["new"] = None

2005-01-27 Thread Lee Jensen
I have postgres 7.4.6 installed on 2 machines one debian and one freebsd. Both are the most recent installs of each OS. On both I have the plpython module and both are having the same issue. Essentially when a function is called from a trigger the TD tuple get's populated with all the standard