Skip site navigation (1) Skip section navigation (2)

Re: Composite Keys

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: (view raw or whole thread)
Lists: pgsql-general

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                               
> 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:
Sent from the PostgreSQL - general mailing list archive at

In response to

pgsql-general by date

Next:From: Dave PageDate: 2007-02-26 19:06:31
Subject: Re: [GENERAL] PostgreSQL on Windows Paper
Previous:From: Andrew HammondDate: 2007-02-26 18:49:23
Subject: Re: help required regarding queryin postgis database from google maps

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group