Thread: 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'
> 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, Pennsylvania19026
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, Pennsylvania19026