Search Postgresql Archives

Re: Composite Keys

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux