Re: Re: JDBC changes for 7.2... some questions... - Mailing list pgsql-jdbc

>
> What's your thoughts?  Do you see the need for the functionality?  Do you have
> a solution that I need?

Definitely need the functionality. It's one of the things holding up me
porting an Informix system. Laziness is a bigger holdup of course - the
Informix system is so bulletproof and I'm slowly re-writing all the 4GL in
Java.

FWIW, Informix returns the new SERIAL value through a structure
SQLCA.SQLERRD[3] from memory. Not applicable to a PostgreSQL solution I'd
say.

>
> On 22-Aug-2001 Barry Lind wrote:
> > I am assuming that this would be a new function in the server.
> > Therefore this wouldn't be jdbc specific and would be available to all
> > client interfaces.  I don't see what this really has to do with JDBC.
> >
> > thanks,
> > --Barry
> >
> > Ned Wolpert wrote:
> >> -----BEGIN PGP SIGNED MESSAGE-----
> >> Hash: SHA1
> >>
> >>
> >> Ok, so you're not opposed to the idea then, just the syntax.  Does anyone
> >> oppose having this concept in the JDBC driver?  And what syntax is
> >> acceptable?
> >> Could we just do
> >> 'select getInsertedOID()'
> >> which would break people who have functions called getInsertedOID() of
> >> course...
> >>
> >>
> >>
> >> On 21-Aug-2001 Tom Lane wrote:
> >>
> >>>Ned Wolpert <ned.wolpert@knowledgenet.com> writes:
> >>>
> >>>>What about the 'select @@last_oid' to make the getInsertedOID() call
> >>>>available even when the driver is wrapped by a pooling manager?
> >>>>
> >>>>How do people feel about this?
> >>>>
> >>>Yech.  At least, not with *that* syntax.  @@ is a valid operator name
> >>>in Postgres.
> >>>
> >>>                      regards, tom lane
> >>>
> >>>---------------------------(end of broadcast)---------------------------
> >>>TIP 5: Have you checked our extensive FAQ?
> >>>
> >>>http://www.postgresql.org/users-lounge/docs/faq.html
> >>>
> >>
> >>
> >> Virtually,
> >> Ned Wolpert <ned.wolpert@knowledgenet.com>
> >>
> >> 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
> >>
> >> iD8DBQE7gv5yiysnOdCML0URAq7qAJkBRhAcE9wctn7bUAv7UMwN3n9+nwCeJR4V
> >> ymYTw8l3f9WU4V5idFsibAE=
> >> =UQ2M
> >> -----END PGP SIGNATURE-----
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 2: you can get off all lists at once with the unregister command
> >>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >>
> >>
>
>
> Virtually,
> Ned Wolpert <ned.wolpert@knowledgenet.com>
>
> 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
>
> iD8DBQE7g+agiysnOdCML0URAvbvAJ9GO/spmwQYZessjk4IenhtPuguSwCdHRQN
> xH+tnGqKpmg/UOSnxOevek0=
> =pcr+
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>