-----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
