Re: [CORE] FOR SHARE vs FOR UPDATE locks

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>
To: josh@agliodbs.com
Cc: pgsql-core@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>, Heikki Linnakangas <heikki@enterprisedb.com>, Alvaro Herrera <alvherre@commandprompt.com>, Simon Riggs <simon@2ndquadrant.com>, pgsql-hackers@postgresql.org
Date: 2006-12-01T19:16:27Z
Lists: pgsql-hackers, pgsql-docs
Josh Berkus wrote:
> Tom,
> 
> > 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.
> 
> Yes.  If it was earlier in the beta cycle I'd say no, but frankly this 
> behavior has existed for two years without examples of real-life data 
> loss.  Further, the TPC tests, which are supposed to give ACID properties 
> a workout, would not break this, so the industry doesn't consider it very 
> important either.
> 
> So, I think it needs to go on the list for 8.2.1 or 8.3 (depending on what 
> changes the fix requires) but I don't think we should hold up the release.

We cannot add something this major in a minor release --- it would have
to be 8.3.

-- 
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +