Search Postgresql Archives

Does PERFORM hold a lock?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: <pgsql-general@xxxxxxxxxxxxxx>
Subject: Does PERFORM hold a lock?
From: "Peter Headland" <pheadland@xxxxxxxxxxx>
Date: Tue, 11 Aug 2009 11:12:10 -0700
Thread-index: Acoarz66CNJU9juKSduKv4j+XiLHBw==
Thread-topic: Does PERFORM hold a lock?

Title: 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Does PERFORM hold a lock?
  - From: Alvaro Herrera

Prev by Date: Re: mail alert
Next by Date: Race hazard deleting using CTID?
Previous by thread: mail alert
Next by thread: Re: Does PERFORM hold a lock?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux