Re: How to lock a table

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: "Morten W(dot) Petersen" <morten(at)src(dot)no>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to lock a table
Date: 2000-07-05 14:38:08
Message-ID: 39634850.1113C069@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Good 2000-07-05 14:51:15 Re: pg respawning too fast
Previous Message Trond Eivind=?iso-8859-1?q?_Glomsr=F8d?= 2000-07-05 14:30:42 Re: [HACKERS] Re: Revised Copyright: is this morepalatable?