Re: OID wraparound (was Re: pg_depend) - Mailing list pgsql-hackers

From Ashley Cambrell
Subject Re: OID wraparound (was Re: pg_depend)
Date
Msg-id 3B5674BB.1080609@freaky-namuh.com
Whole thread Raw
In response to Re: OID wraparound (was Re: pg_depend)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tom Lane wrote:
>Lamar Owen <lamar.owen@wgcr.org> writes:>>><snip>>>>><snip>>>Another possibility, given that any app using a feature
likethis is>nonportable anyway, is to extend the INSERT statement along the lines>that someone (maybe Larry R?  I
forgetnow) proposed before:>>    INSERT INTO foo ... RETURNING x,y,z,...>>where x,y,z, etc are expressions in the
variablesof the inserted>tuple(s).  This could be made to look like a SELECT at the protocol>level, which would mean
thatit wouldn't break client libraries or>require a protocol bump, and it's *way* more flexible than any>hardwired
decisionabout what columns to return.  It wouldn't have>any problem with multiple tuples inserted by an INSERT ...
SELECT,>either.>

This would be a good thing (tm).  I use Oracle quite extensively as well
as PG and Oracle's method of "RETURNING :avalue" is very good for
returning values from newly inserted rows.

There was some talk a while back about [not?] implementing variable
binding.  This seems to become very closely related to that. It would 
seem to solve the problem of having a unique identifier returned for 
inserts.  I'm sure it would please quite a few people in the process, 
especially ones moving across from Oracle.  (kill two birds with one stone)
>>     regards, tom lane>

Ashley Cambrell





pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: OID wraparound (was Re: pg_depend)
Next
From: Philip Warner
Date:
Subject: Re: OID wraparound (was Re: pg_depend)