pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Mount <peter@retep.org.uk>
To: maet@gmx.de
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [INTERFACES] object id
Date: Mon, 12 Mar 2001 20:12:20 +0000
Message-ID: <5.0.2.1.0.20010312201101.00a27990@mail.retep.org.uk> (raw)
In-Reply-To: <378.984421346@www32.gmx.net>
References: <5.0.2.1.0.20010312160856.0216c080@mail.retep.org.uk>

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




view thread (7+ messages)

Message-ID: <5.0.2.1.0.20010312201101.00a27990@mail.retep.org.uk>
Permalink:  ../5.0.2.1.0.20010312201101.00a27990@mail.retep.org.uk/
Also on:    postgresql.org/message-id/5.0.2.1.0.20010312201101.00a27990@mail.retep.org.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: peter@retep.org.uk, maet@gmx.de, pgsql-jdbc@postgresql.org
  Subject: Re: [INTERFACES] object id
  In-Reply-To: <5.0.2.1.0.20010312201101.00a27990@mail.retep.org.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox