Re: prepare, execute & oids

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: phazon <phazon(dot)ml(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: prepare, execute & oids
Date: 2006-08-01 18:47:25
Message-ID: 20060801184725.GA18690@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 01, 2006 at 06:19:29PM +0200, phazon wrote:
> I juste want to get the OID of the line inserted. Does anyone know how to do
> it ?

It depends on the client interface. What interface are you using?

OIDs are deprecated as row identifiers; the preferred method is to
use a sequence (serial column). To get a sequence's value you can
use currval() or lastval() (the latter available in 8.1).

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sundar Narayanaswamy 2006-08-01 18:48:04 Re: Autovacuum help..
Previous Message Michael Fuhr 2006-08-01 18:36:18 Re: Can you run out of oids?