Does PERFORM hold a lock? - Mailing list pgsql-general

From Peter Headland
Subject Does PERFORM hold a lock?
Date
Msg-id 71F491F5DA99604A80DE49424BF3D02B0C729378@exchange8.actuate.com
Whole thread Raw
Responses Re: Does PERFORM hold a lock?
List 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

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: mail alert
Next
From: "Peter Headland"
Date:
Subject: Race hazard deleting using CTID?