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

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