-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Oleg (et al)-
I'm currently trying to run down techniques to get the postgresql driver to
help us with sequence key generators. Specifically, I'm trying to see if they
will start supporting the RETURNING clause like oracle does for prepared
statements. The other option is getting the identity key generator to work
with postgres like it does with sybase. Questions I have for you folks are:
1) Which do you like better? (I think the returning clause personally, but that
needs more support for the backend, and I don't know the status on that yet.
2) Can the identity sequence work with the OID rather than a sequence table
within Castor? By this, I mean specifically, each row in Postgresql has a
specific identity that is unqiue across all rows in postgres. This is a
number. Postgresql jdbc driver has a method called getInsertedOID() that
returns the last inserted row's oid, but is only available with a direct
instance of the driver. (Which you don't have in a pooled environment.) I'm
trying to see if postgresql folks will allow using a SQL statement like
"select @@last_oid"
to get this value. If so, Castor can use the OID to unquely identify rows in
the database, rather than a seperate identifier. Does this work in Castor?
If so, then I'll submit a patch for this for the 7.2 release of psql.
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
iD8DBQE7gsFeiysnOdCML0URAuf8AJsFIhoCQFpfnn+CKBSwtBJG1LOx7QCfYi39
bgQOsCuKYc8POjW8BZ5yTEQ=
=pnQ9
-----END PGP SIGNATURE-----
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
