lock table - Mailing list pgsql-hackers

From Jose' Soares
Subject lock table
Date
Msg-id 363720E1.1A52E02F@sferacarta.com
Whole thread Raw
Responses Re: [HACKERS] lock table  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] lock table  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
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'


pgsql-hackers by date:

Previous
From: "Jose' Soares"
Date:
Subject: serial type
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] s_lock.h line 178