pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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