Thread: Does PERFORM hold a lock?

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

Peter Headland wrote:
> 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;

Yes.  (PERFORM is translated to SELECT by the plpgsql engine, so to the
SQL executor this is the same as SELECT FOR UPDATE).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.