Re: performance issue using DBI - Mailing list pgsql-general

From Oliver Elphick
Subject Re: performance issue using DBI
Date
Msg-id 1023380046.26291.2977.camel@linda
Whole thread Raw
In response to Re: performance issue using DBI  ("Joshua b. Jore" <josh@greentechnologist.org>)
Responses Re: performance issue using DBI
Re: [ADMIN] performance issue using DBI
List pgsql-general
On Thu, 2002-06-06 at 14:55, Joshua b. Jore wrote:u
>       Don't use currval since some other process might alter the
> sequence between the time you call nextval and currval.

This is wrong.  currval() will always return the last serial assigned in
*the*same*session*.  It is not affected by other users at all.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "Therefore being justified by faith, we have peace with
      God through our Lord Jesus Christ."       Romans 5:1

Attachment

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: pg_shadow
Next
From: Carl Worth
Date:
Subject: Confusion regarding sub-second time input