Re: Bug in triggers - Mailing list pgsql-bugs

From Chris Travers
Subject Re: Bug in triggers
Date
Msg-id 5ed37b141003100830s16246f91rfee3fe7f167ac21b@mail.gmail.com
Whole thread Raw
In response to Re: Bug in triggers  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
On Wed, Mar 10, 2010 at 8:20 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Tue, Mar 9, 2010 at 11:02 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> We may need to document it, but not like that; it's (a) incorrect and
>> (b) unhelpful to the reader, who is left without any clear idea of what
>> to avoid. =A0I think that the real issue here doesn't have anything to do
>> with NEW/OLD as such, but is related to the representational difference
>> between record and row variables.
>
> I agree. =A0That's precisely what I'm confused about.
>

- Show quoted text -
On Wed, Mar 10, 2010 at 8:20 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Tue, Mar 9, 2010 at 11:02 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> We may need to document it, but not like that; it's (a) incorrect and
>> (b) unhelpful to the reader, who is left without any clear idea of what
>> to avoid.  I think that the real issue here doesn't have anything to do
>> with NEW/OLD as such, but is related to the representational difference
>> between record and row variables.
>
> I agree.  That's precisely what I'm confused about.

Additionally, plpgsql uses "record" seemingly to refer to row
variables, so pointing folks to this conversation may not necessarily
clear up confusion....

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: Bug in triggers
Next
From: Simon Riggs
Date:
Subject: Re: PD_ALL_VISIBLE flag error on 9.0 alpha 4