> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> "INSERT/UPDATE ... RETURNING" isn't something a driver can take
> It would require it to modify your statements which it can't do
> your application would have such non-portable SQL code written into
> databases and your application code needs to be ported.
I really don't think it matters. Currently, in PostgreSQL, there is
only 'one true way' to have a real unique identifier for any given tuple
that is persistent across queries and this is a sequence. Since
sequences are basically managed by the app, your driver (I'm assuming)
can't reliably use them.
This is kind of similar to the issues being talked about wrt user locks.
Because the lack of a true persistent tuple identifier, they require
some data to be passed to them from the app (not really a big deal for
From the point of view of your driver, the real solution is to bump oid
to 64 bits and un-deprecate it.
pgsql-hackers by date
|Next:||From: Dann Corbit||Date: 2005-02-02 17:21:09|
|Subject: Enhancement suggestion|
|Previous:||From: Bruce Momjian||Date: 2005-02-02 17:14:00|
|Subject: Re: 7.3.8 under FC3 takes excessive semaphores?|