| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Mark Cave-Ayland <mark(dot)cave-ayland(at)webbased(dot)co(dot)uk> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Ref to last INSERT on a table without OIDs? |
| Date: | 2003-01-28 16:14:19 |
| Message-ID: | 20030128081334.Q93245-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-01-28 16:15:08 | Re: Using RSYNC for replication? |
| Previous Message | Tom Lane | 2003-01-28 16:12:57 | Re: alter database/user set problem |