Re: [INTERFACES] object id

From: Peter Mount <peter(at)retep(dot)org(dot)uk>
To: maet(at)gmx(dot)de
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [INTERFACES] object id
Date: 2001-03-12 20:12:20
Message-ID: 5.0.2.1.0.20010312201101.00a27990@mail.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-jdbc

At 19:22 12/03/01 +0100, maet(at)gmx(dot)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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2001-03-12 20:15:01 Re: Compiling JDBC - problem
Previous Message Peter Mount 2001-03-12 20:10:38 Re: [INTERFACES] JDBC: can't set transaction isolation level

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Mount 2001-03-12 20:19:03 Re: JDBC build patches
Previous Message Peter Mount 2001-03-12 20:10:38 Re: [INTERFACES] JDBC: can't set transaction isolation level