Received: from mail.retep.org.uk ([216.126.85.184])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2CKEHx58502
	for <pgsql-jdbc@postgresql.org>; Mon, 12 Mar 2001 15:14:17 -0500 (EST)
	(envelope-from peter@retep.org.uk)
Received: from heather.retep.org.uk ([193.113.118.126]) (authenticated)
	by mail.retep.org.uk (8.11.1/8.11.1) with ESMTP id f2CKEER58492;
	Mon, 12 Mar 2001 15:14:14 -0500 (EST)
	(envelope-from peter@retep.org.uk)
Message-Id: <5.0.2.1.0.20010312201101.00a27990@mail.retep.org.uk>
X-Sender: peter@mail.retep.org.uk
X-Mailer: QUALCOMM Windows Eudora Version 5.0.2
Date: Mon, 12 Mar 2001 20:12:20 +0000
To: maet@gmx.de
From: Peter Mount <peter@retep.org.uk>
Subject: Re: [INTERFACES] object id
Cc: pgsql-jdbc@postgresql.org
In-Reply-To: <378.984421346@www32.gmx.net>
References: <5.0.2.1.0.20010312160856.0216c080@mail.retep.org.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
X-Archive-Number: 200103/57
X-Sequence-Number: 271

At 19:22 12/03/01 +0100, maet@gmx.de wrote:
> >Hmm, not really. The only oid you can get is one from an Insert, but thats
> >for the most recent row inserted.
>
>
>How do i get the oid from the blob of the most recent row inserted?

The only way is to re-query the row as only the oid of the row is returned 
during the insert.

The only other way is to use the largeobject api (not JDBC) and then you 
have the oid before any inserts.

Peter