Thread: How to lock a table

We're trying to use a unique-identifier scheme in a database; and
therefore we need to put a lock on a table.

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

-Morten

-------------------------------------------------------------
How to reply to email:
  http://home.sol.no/~vidaandr/news/OBSquoting.html (norsk)
  http://home.sol.no/~vidaandr/news/FAQquoting.html (english)

Who is the bigger fool? The fool or the fool who follows him?

> 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