Re: How to lock a table - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: How to lock a table
Date
Msg-id 39634850.1113C069@alumni.caltech.edu
Whole thread Raw
In response to How to lock a table  ("Morten W. Petersen" <morten@src.no>)
List pgsql-general
> We're trying to use a unique-identifier scheme in a database; and
> therefore we need to put a lock on a table.

Are you sure? Please describe the problem which absolutely requires a
full table-level lock...

> Is there some way to do this using the PyGres (python) adapter?

select * from t1 where 1 = 0;

or

lock table t1;

                      - Thomas

pgsql-general by date:

Previous
From: jprem
Date:
Subject: help -- cursor inside a function
Next
From: "James L. Hall"
Date:
Subject: pg respawning too fast