Re: GET DIAGNOSTICS (was Re: Open 7.1 items) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: GET DIAGNOSTICS (was Re: Open 7.1 items)
Date
Msg-id 12526.982683252@sss.pgh.pa.us
Whole thread Raw
In response to Re: GET DIAGNOSTICS (was Re: Open 7.1 items)  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Bruce Momjian writes:
> I just committed changes that make it RESULT_OID, but if you like
> INSERTED_OID better, we could change it...
>> 
>> I think I like RESULT_OID because the standard uses RESULT.

> RESULT* is used for SELECT statements, but RESULT_OID is for INSERT
> commands.  It sounds a bit like that results get oids assigned.  Maybe.

I don't have a strong feeling either way, but it occurred to me that
RESULT_OID might be better since it could be used for more purposes,
eg, returning a last-affected-row OID for UPDATE or DELETE.  Not that
we do that now, but we wouldn't have to chew up additional keywords
if we wanted to start doing it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: GET DIAGNOSTICS (was Re: Open 7.1 items)
Next
From: Peter Eisentraut
Date:
Subject: Re: enable-debug considered pointless