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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
