LOCK command

Started by Bruce Momjianover 28 years ago3 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

I have implemented LOCK tablename for 6.3. It just does a DELETE table
WHERE false.

--
Bruce Momjian
maillist@candle.pha.pa.us

#2Vadim Mikheev
vadim@krs.ru
In reply to: Bruce Momjian (#1)
Re: [HACKERS] LOCK command

Bruce Momjian wrote:

I have implemented LOCK tablename for 6.3. It just does a DELETE table
WHERE false.

Unfortunately, this will be useful inside BEGIN/END only :(

Vadim

#3Bruce Momjian
bruce@momjian.us
In reply to: Vadim Mikheev (#2)
Re: [HACKERS] LOCK command

Bruce Momjian wrote:

I have implemented LOCK tablename for 6.3. It just does a DELETE table
WHERE false.

Unfortunately, this will be useful inside BEGIN/END only :(

Vadim

Well, if they issue a LOCK outside a transaction, it doesn't do
anything. To be usefull outside a transaction, we would have to have a
LOCK/UNLOCK command, and I am not at that point yet.

--
Bruce Momjian
maillist@candle.pha.pa.us