From: | RPK <rohitprakash123(at)indiatimes(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Composite Keys |
Date: | 2007-02-26 18:56:20 |
Message-ID: | 9166441.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-02-26 19:06:31 | Re: [GENERAL] PostgreSQL on Windows Paper |
Previous Message | Andrew Hammond | 2007-02-26 18:49:23 | Re: help required regarding queryin postgis database from google maps |