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.