pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kris Kiger <kris@musicrebellion.com>
Cc: Pgsql-Admin (E-mail) <pgsql-admin@postgresql.org>
Subject: Re: Functions and transactions
Date: Fri, 11 Mar 2005 13:54:33 -0500
Message-ID: <4363.1110567273@sss.pgh.pa.us> (raw)
In-Reply-To: <4231CBEE.60109@musicrebellion.com>
References: <421CF15C.6010306@turtle-entertainment.de>
<421CF1CE.3000800@turtle-entertainment.de>
<422F6203.1090800@musicrebellion.com>
<7701.1110407641@sss.pgh.pa.us>
<42305968.10100@musicrebellion.com>
<15242.1110469332@sss.pgh.pa.us>
<4230A6AA.6030204@musicrebellion.com>
<27098.1110499829@sss.pgh.pa.us>
<4231CBEE.60109@musicrebellion.com>
Kris Kiger <kris@musicrebellion.com> writes:
> Interesting. That makes sense, though. So, is there a good way to lock
> a set of rows using SELECT FOR UPDATE in plpgsql? I assume using
> PERFORM would yield the same problem, because it immediately discards
> the results.
I think PERFORM would work. The fact that plpgsql ignores the results
doesn't mean you don't have lock on the rows.
regards, tom lane
view thread (11+ messages)
Message-ID: <4363.1110567273@sss.pgh.pa.us> Permalink: ../4363.1110567273@sss.pgh.pa.us/ Also on: postgresql.org/message-id/4363.1110567273@sss.pgh.pa.us ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-admin@postgresql.org Cc: tgl@sss.pgh.pa.us, kris@musicrebellion.com Subject: Re: Functions and transactions In-Reply-To: <4363.1110567273@sss.pgh.pa.us> References: <421CF15C.6010306@turtle-entertainment.de> <421CF1CE.3000800@turtle-entertainment.de> <422F6203.1090800@musicrebellion.com> <7701.1110407641@sss.pgh.pa.us> <42305968.10100@musicrebellion.com> <15242.1110469332@sss.pgh.pa.us> <4230A6AA.6030204@musicrebellion.com> <27098.1110499829@sss.pgh.pa.us> <4231CBEE.60109@musicrebellion.com> <4363.1110567273@sss.pgh.pa.us> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox