Re: [GENERAL] 8.1, OID's and plpgsql - Mailing list pgsql-hackers

From Greg Stark
Subject Re: [GENERAL] 8.1, OID's and plpgsql
Date
Msg-id 87ek4pik91.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: [GENERAL] 8.1, OID's and plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] 8.1, OID's and plpgsql
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Rather than hard-wiring a special case for any of these things, I'd much
> rather see us implement INSERT...RETURNING and UPDATE...RETURNING as per
> previous suggestions.  Then you can fetch pkey, ctid, or whatever you
> need.

I happen to think UPDATE RETURNING is one of the coolest things since sliced
bread, but that's because it saved my ass once in my last job.

I wonder whether the ui tools need anything more low level than that. In
general sticking their grubby fingers in the query the user entered seems
wrong and they would have to tack on a RETURNING clause. Though I can't really
see it failing in this particular instance.

-- 
greg



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Upcoming PG re-releases
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] 8.1, OID's and plpgsql