Skip site navigation (1) Skip section navigation (2)

Re: pgsql: Reset ALTER TABLE lock levels to AccessExclusiveLock in all case

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-committers <pgsql-committers(at)postgresql(dot)org>
Subject: Re: pgsql: Reset ALTER TABLE lock levels to AccessExclusiveLock in all case
Date: 2011-07-10 10:30:05
Message-ID: CA+U5nMJ-PKFHveR3+73omNMmiWAAb=51tE_eMwH_b6=ViaLHQQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-committers
On Thu, Jul 7, 2011 at 6:17 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> On Mon, Jul 4, 2011 at 6:14 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>>>> Reset ALTER TABLE lock levels to AccessExclusiveLock in all cases.
>>>> Locks on inheritance parent remain at lower level, as they were before.
>>>> Remove entry from 9.1 release notes.
>
>> I believe you need a similar fix in CreateTrigger() and DefineQueryRewrite().
>
> I took care of this.

Thanks.

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

pgsql-committers by date

Next:From: User FxjrDate: 2011-07-11 13:33:21
Subject: npgsql - Npgsql2: Added patch from Patrick Earl.
Previous:From: Robert HaasDate: 2011-07-09 02:19:48
Subject: pgsql: Try to acquire relation locks in RangeVarGetRelid.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group