Alvaro, I am using VB.NET. How to enable locking from within VB.NET for PostgreSQL? Which command need to be executed?
Alvaro Herrera-7 wrote: > >>Lock the table beforehand. Only one user can be getting the >>max(ReceiptNo) that way. > >>Alternatively, you could use userlocks, so that you can lock, generate >>the number, unlock. And you can use it to lock that particular BookNo, >>not the whole table. (In Postgres 8.2 the facility is called "advisory >>locks" and comes with the core code; in older releases it's in contrib >>and it's called "userlock"). > > -- > Alvaro Herrera > http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > > -- View this message in context: http://www.nabble.com/Composite-Keys-tf3282722.html#a9166441 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
