Thanks Ned,
now I recalled the issue. I like "select @@last_oid" more than RETURNING
clause, but it's probably the question of personal taste :)
Oleg
On Wednesday 22 August 2001 00:47, Ned Wolpert wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 21-Aug-2001 Oleg Nitz wrote:
> > It seems to me that we've done the "trigger" mode for SEQUENCE key
> > generator with Postgres, in this mode "SELECT pk FROM table WHERE OID=?"
> > is used to get the pk, where OID is obtained via getInsertedOID. Doesn't
> > it work for you?
>
> Actually, no, it doesn't. Reason is, I'm using PoolMan. The
> getInsertedOID() method isn't available since PoolMan wraps the statement
> and result set classes in its own classes. (It took me abit to track down
> this error last May...) So, yes, it works great when connections are not
> pooled. Unfortunately, this isn't an option for me.
>
> > Isn't it what you want?
>
> At this rate, I'd like to have the JDBC driver from postgres have the
> ability to call getInsertedOID() like sybase does, "select @@last_oid" or
> something like that. Looks like the returning mode won't be there until
> Postgres 7.3 at this rate. Back in May, when I first brought this up, I
> thought that psql 7.2 was going to have this implemented in the backend, so
> we didn't have to fake it in the driver. Some issues came up that stopped
> this from getting implemented in the 7.2 requirements.
>
>
>
>
>
> Virtually,
> Ned Wolpert <[EMAIL PROTECTED]>
>
> D08C2F45: 28E7 56CB 58AC C622 5A51 3C42 8B2B 2739 D08C 2F45
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.6 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
>
> iD8DBQE7gtbniysnOdCML0URAgjBAJ9O8xIYWP0zX6rHK1S/bS3SquhAVQCfSFdX
> VZbwlZDnIQb+Khd3CP7DNNo=
> =HUz5
> -----END PGP SIGNATURE-----
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
