Julian North wrote:
> Hi,
>
> I am in the process of porting a number of large MSSQL databases to
> Postgres.
>
> The current id generation model in SQL server is an oracle style sequence
> generator i wrote using a pretty simple stored proc and table structure.
>
> I now need to do the same thnig in postgres.
>
> In MSSQL I was able to open an UPDATE cursor, which places a lock on the row
> in the sequence table. I then update, release and return.
>
> Has anyone done something similar or have any pointers on how to do this
> safely, securely without an update cursor?
Are you trying to do this?
http://developer.postgresql.org/docs/postgres/functions-sequence.html
Sequence values are transaction safe in postgreql. You don't have to lock
anything to get a correct and unique sequence value.
HTH
Shridhar