Does PERFORM hold a lock?

From: "Peter Headland" <pheadland(at)actuate(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Does PERFORM hold a lock?
Date: 2009-08-11 18:12:10
Message-ID: 71F491F5DA99604A80DE49424BF3D02B0C729378@exchange8.actuate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If I do the following in a pl/pgsql function, will an update lock be
held until the end of the transaction?

PERFORM c FROM t FOR UPDATE;

--
Peter Headland
Architect
Actuate Corporation

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Headland 2009-08-11 18:29:26 Race hazard deleting using CTID?
Previous Message Christophe Pettus 2009-08-11 17:38:49 Re: mail alert