lock table

From: "Jose' Soares" <jose(at)sferacarta(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: lock table
Date: 1998-10-28 13:49:21
Message-ID: 363720E1.1A52E02F@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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'

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 1998-10-28 14:19:03 Re: [HACKERS] Open 6.4 items
Previous Message Jose' Soares 1998-10-28 13:27:27 serial type