Re: [GENERAL] column-level update privs + lock table
Josh Kupershmidt <schmiddy@gmail.com>
From: Josh Kupershmidt <schmiddy@gmail.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2010-10-15T19:49:48Z
Lists: pgsql-hackers
Attachments
- column_level_lock.patch (application/octet-stream) patch
[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