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?
Any infor appreciated.
Cheers,
Julian.
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________