Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 0524A632C55
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 13 Apr 2009 18:43:05 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 30840-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 13 Apr 2009 18:42:58 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gx0-f172.google.com (mail-gx0-f172.google.com
	[209.85.217.172])
	by mail.postgresql.org (Postfix) with ESMTP id 4A9AA6321A9
	for <pgsql-sql@postgresql.org>; Mon, 13 Apr 2009 18:43:03 -0300 (ADT)
Received: by gxk20 with SMTP id 20so29788gxk.19
	for <pgsql-sql@postgresql.org>; Mon, 13 Apr 2009 14:43:02 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=P4FeVultAeO+7DkVCNRbcKsSJ9Vx0nA0r+yJe3DXnkc=;
	b=D+v0EVTVLWAmhYs73opH9HCp6x9O27Urp41FLdDPUN359ty+URY8LhFc0MQRIKqI5g
	yVGlAf6msU1xVVa8CG5oeLaR9MW06xkzfvSLEN8Z2kAEK/+j4ezKosGUGInuJD9PL4s5
	moN2FSVi1p9tVIkp7fpqxMJ9pLCdLQorm3xzc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=aFjeK9TKzTAqtLaxZ9YClpOpGpDlV4CCRpd+KdzKpOHDuB2CTg4+Dqa1hT8tBGtvWi
	G0NROwiDnPeJGRFho3VXYSWFFJfSfuLcLouO9MbdccWftVMrZfyIRX7KtVE5d5hGlbUC
	6NkZ6UTRdr48Cv7TOdycXNpYaDeUATAz188WE=
MIME-Version: 1.0
Received: by 10.150.97.20 with SMTP id u20mr9128470ybb.214.1239658981812;
 Mon,
	13 Apr 2009 14:43:01 -0700 (PDT)
In-Reply-To: <d18085b50904131432o1d3af00ci250d1077024648f5@mail.gmail.com>
References: <49DC1034.1060705@frii.com>
	<dcc563d10904101120y49f00977nc74132e982518444@mail.gmail.com>
	<49E37441.6030301@frii.com>
	<d18085b50904131409g10d43d6cs35dd14ede13bc02@mail.gmail.com>
	<396486430904131418g3898dc5h2472f9efab331489@mail.gmail.com>
	<d18085b50904131432o1d3af00ci250d1077024648f5@mail.gmail.com>
Date: Mon, 13 Apr 2009 14:43:01 -0700
Message-ID: <396486430904131443w72ded091qe59c709c76dd0960@mail.gmail.com>
Subject: Re: changing multiple pk's in one update
From: Richard Broersma <richard.broersma@gmail.com>
To: Glenn Maynard <glennfmaynard@gmail.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200904/65
X-Sequence-Number: 32411

On Mon, Apr 13, 2009 at 2:32 PM, Glenn Maynard <glennfmaynard@gmail.com> wr=
ote:

>=A0If your senses are reordered by someone else, and
> you operate on /10/3, you may suddenly find yourself viewing or
> modifying (or deleting!) a different sense. =A0This could even happen
> within the same transaction, if you're not very careful with
> locking...