Re: performance issue using DBI

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