Hi Ned,
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?
Isn't it what you want?
Do you want to avoid the additional SELECT by setting pk=OID?
Can we write "INSERT INTO table (pk,...) VALUES (OID,...)?
Then we would get the RETURNING mode, getInsertedOID will give us the
inserted value.
Oleg
On Tuesday 21 August 2001 23:15, Ned Wolpert wrote:
> -----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
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
