Re: FOR SHARE vs FOR UPDATE locks - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: FOR SHARE vs FOR UPDATE locks
Date
Msg-id 1165006016.3778.888.camel@silverbirch.site
Whole thread Raw
In response to Re: FOR SHARE vs FOR UPDATE locks  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: FOR SHARE vs FOR UPDATE locks  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, 2006-12-01 at 13:46 -0500, Tom Lane wrote:

> I'm also realizing that a fix along the throw-an-error line is
> nontrivial, eg, HeapTupleSatisfiesUpdate would need another return code.

Yes, thats starting to get hairy. The fix could easily break something
else in another corner of MVCC.

> So at this point we are facing three options:
>     - throw in a large and poorly tested "fix" at the last moment;
>     - postpone 8.2 until we can think of a real fix, which might
>       be a major undertaking;
>     - ship 8.2 with the same behavior 8.0 and 8.1 had.
> None of these are very attractive, but I'm starting to think the last
> is the least bad.

The functionality in this area isn't yet complete anyway; we still have
locking in the partitioned table case to consider. It's not that bad
just to leave it as is. So last option gets my vote.

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)
Next
From: Tom Lane
Date:
Subject: Re: FOR SHARE vs FOR UPDATE locks