Re: sequence integrity insite begin-commit?

On 03 May 2001 01:00:14 +1200, Rob Brown-Bayliss wrote:
> Hi.  I am develeoping an app with python that uses postgresql.
> I have hit a snag in that I need to know the value of a sequence from an
> insert just performed, but the interface from python to postgres (called
> PoPy) does not return the oid from the insert as psql does.
>
> So what I am doing is begining a transaction, inserting the data,
> selecting the last_value from the sequence and then commiting the
> transaction.
>
> I ma not sure if this will work in the real world as what happens if
> between one user inserting their data if another insets data as well?
> will the last_value from the sewuence (inside the transaction) be
> correct, or will it show the valu for the second user?
>
> Am I being clear? try this
>
>     USER ONE     |     USER TWO
>     ===========================
>     Begin        | Begin
>     Insert       | Insert
>     Select       | Select
>     Commit       | Commit
>
> If these two are happening at the same time (or as near as is possible
> can I rely on the selected last_value being the sequence value that was
> inserted by the user?  (the sequence is the default falue for a column
> and user does not enter it)
>
>
> Thanks
>
> --
>
>   Rob Brown-Bayliss
>  ---======o======---
>   www.ZOOstation.cc

--

  Rob Brown-Bayliss
 ---======o======---
  www.ZOOstation.cc