Hi all,

I would to report that LOCK TABLE doesn't work outside
transactions but PostgreSQL accepts this statement outside
transactions whithout saying nothing...

prova=> begin work;
BEGIN
prova=> select * from films where code = 'BL102';
code |title            |did| date_prod|kind      |len
-----+-----------------+---+----------+----------+-----
BL102|The African Queen|101|1951-08-11|Drama     |01:43
(1 row)

prova=> commit work;
END
prova=> lock table films;
DELETE 0

Jose'

Wed, 28 Oct 1998 14:49:21 +0100
"Jose' Soares" <jose@sferacarta.com>
lock table
> Hi all,
> 
> I would to report that LOCK TABLE doesn't work outside
> transactions but PostgreSQL accepts this statement outside
> transactions whithout saying nothing...
> 
> prova=> begin work;
> BEGIN
> prova=> select * from films where code = 'BL102';
> code |title            |did| date_prod|kind      |len
> -----+-----------------+---+----------+----------+-----
> BL102|The African Queen|101|1951-08-11|Drama     |01:43
> (1 row)
> 
> prova=> commit work;
> END
> prova=> lock table films;
> DELETE 0
> 
> Jose'

Good point. I should fix that someday.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 28 Oct 1998 11:20:43 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] lock table
Added to TODO.


> Hi all,
> 
> I would to report that LOCK TABLE doesn't work outside
> transactions but PostgreSQL accepts this statement outside
> transactions whithout saying nothing...
> 
> prova=> begin work;
> BEGIN
> prova=> select * from films where code = 'BL102';
> code |title            |did| date_prod|kind      |len
> -----+-----------------+---+----------+----------+-----
> BL102|The African Queen|101|1951-08-11|Drama     |01:43
> (1 row)
> 
> prova=> commit work;
> END
> prova=> lock table films;
> DELETE 0
> 
> Jose'
> 
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 11 Dec 1998 11:51:44 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] lock table