Postgres Pro
Downloads
Home   >   mailing lists

Re: How to lock and unlock table in postgresql - Mailing list pgsql-general

From John R Pierce
Subject Re: How to lock and unlock table in postgresql
Date
Msg-id 4EC4A844.6090303@hogranch.com
Whole thread Raw
In response to How to lock and unlock table in postgresql  (Siva Palanisamy <siva_p@hcl.com>)
Responses Re: How to lock and unlock table in postgresql  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
On 11/16/11 10:10 PM, Siva Palanisamy wrote:
>
> If there is a better solution, kindly let me know.
>

use nextval('seqname') ... full transactional integrity without any
blocking or locking.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

pgsql-general by date:

Previous
From: Siva Palanisamy
Date:
Subject: How to lock and unlock table in postgresql
Next
From: John R Pierce
Date:
Subject: Re: How to lock and unlock table in postgresql