Re: [JDBC] New backend functions? [was Re: JDBC changes for 7.2.

From: Ned Wolpert <ned(dot)wolpert(at)knowledgenet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] New backend functions? [was Re: JDBC changes for 7.2.
Date: 2001-08-23 20:03:39
Message-ID: XFMail.20010823130339.ned.wolpert@knowledgenet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I like your function name, get_last_returned_oid(). That works for me.

On 23-Aug-2001 Tom Lane wrote:
> Ned Wolpert <ned(dot)wolpert(at)knowledgenet(dot)com> writes:
>> Should the backend support the function getLastInsertedOID() or even
>> getLastInsertedPrimaryKey() (or both)?
>
> I don't think you have any chance of doing the latter --- for one thing,
> how are you going to declare that function's return type? But the
> former seems doable and reasonable to me: whenever an OID is returned
> to the client in an INSERT or UPDATE command result, also stash it in
> a static variable that can be picked up by this function.
>
> Please pick a more SQL-friendly (ie, case insensitive) naming
> convention, though. And note that it'd apply to both INSERT and UPDATE.
> Maybe get_last_returned_oid() ?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Virtually,
Ned Wolpert <ned(dot)wolpert(at)knowledgenet(dot)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

iD8DBQE7hWGbiysnOdCML0URAkqAAJ9Liv8VS+CPMYozG1q1tuy7vGLuEACfUJRM
Hdbns8MxyOVgurx5ztV8YZU=
=BbF3
-----END PGP SIGNATURE-----

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Florian Weimer 2001-08-23 20:17:05 Re: Re: Escaping strings for inclusion into SQL queries
Previous Message Ned Wolpert 2001-08-23 20:01:52 Re: Re: [JDBC] New backend functions? [was Re: JDBC ch

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bruce Momjian 2001-08-23 20:17:57 Re: [PATCHES] patch for JDBC1 build problems
Previous Message Ned Wolpert 2001-08-23 20:01:52 Re: Re: [JDBC] New backend functions? [was Re: JDBC ch