Re: Ref to last INSERT on a table without OIDs?

From: "Mark Cave-Ayland" <mark(dot)cave-ayland(at)webbased(dot)co(dot)uk>
To: "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Ref to last INSERT on a table without OIDs?
Date: 2003-01-28 16:28:20
Message-ID: C1379626F9C09A4C821D6977AA6A5457033C48@webbased8.wb8.webbased.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> -----Original Message-----
> From: Stephan Szabo [mailto:sszabo(at)megazone23(dot)bigpanda(dot)com]
> Sent: 28 January 2003 16:14
> To: Mark Cave-Ayland
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Ref to last INSERT on a table without OIDs?
>
>
> On Tue, 28 Jan 2003, Mark Cave-Ayland wrote:
>
> > Hi there,
> >
> > Hopefully just a quick one: how is it possible to obtain a reference
to
> > the last inserted record in a table which is created without oids? I
> > would like to dump/restore some of our larger tables so they don't
use
> > oids, however I am concerned that simply getting the current PK
sequence
> > value after insertion within a transaction is not safe when many
people
> > are accessing the table/sequence at once? Can anyone clarify this?
We're
> > using the latest and greatest 7.3.1.
>
> If you use currval() to get the sequence value it'll be the last value
> given to your session so you don't have to worry about other sessions
> modifying the sequence.

Hi Stephan,

Thanks for your reply! But I'm still a little confused by what defines a
session - is it a transaction or a backend? I'm just thinking about
connections from web pages which use PHP pooled connections..... if a
session is a transaction then I'm guessing everything should work fine
without any problems?

Cheers,

Mark.

---

Mark Cave-Ayland
Webbased Ltd.
Tamar Science Park
Derriford
Plymouth
PL6 8BX
England

Tel: +44 (0)1752 764445
Fax: +44 (0)1752 764446

This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender. You
should not copy it or use it for any purpose nor disclose or distribute
its contents to any other person.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomaz Borstnar 2003-01-28 16:30:00 Re: tsearch comments
Previous Message Francisco J Reyes 2003-01-28 16:24:45 Re: Status of tablespaces