Re: [GENERAL] column-level update privs + lock table - Mailing list pgsql-hackers

From Josh Kupershmidt
Subject Re: [GENERAL] column-level update privs + lock table
Date
Msg-id AANLkTim-ay7r4u4R4+Mie6oUpVk89GO06pua3q0h+28H@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] column-level update privs + lock table
Re: [GENERAL] column-level update privs + lock table
List pgsql-hackers
[Moving to -hackers]

On Fri, Oct 15, 2010 at 3:43 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Mon, 2010-10-11 at 09:41 -0400, Josh Kupershmidt wrote:
>> On Thu, Oct 7, 2010 at 7:43 PM, Josh Kupershmidt <schmiddy@gmail.com> wrote:
>>
>> > I noticed that granting a user column-level update privileges doesn't
>> > allow that user to issue LOCK TABLE with any mode other than Access
>> > Share.
>>
>> Anyone think this could be added as a TODO?
>
> Seems so to me, but you raise on Hackers.

Thanks, Simon. Attached is a simple patch to let column-level UPDATE
privileges allow a user to LOCK TABLE in a mode higher than Access
Share. Small doc. update and regression test update are included as
well. Feedback is welcome.

Thanks
Josh

Attachment

pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: How to reliably detect if it's a promoting standby
Next
From: Tom Lane
Date:
Subject: Re: UNION DISTINCT in doc