| From: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] column-level update privs + lock table |
| Date: | 2010-10-15 19:49:48 |
| Message-ID: | AANLkTim-ay7r4u4R4+Mie6oUpVk89GO06pua3q0h+28H@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
[Moving to -hackers]
On Fri, Oct 15, 2010 at 3:43 AM, Simon Riggs <simon(at)2ndquadrant(dot)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(at)gmail(dot)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 | Content-Type | Size |
|---|---|---|
| column_level_lock.patch | application/octet-stream | 5.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-10-15 20:59:13 | Re: Strange phenomenon |
| Previous Message | Tom Lane | 2010-10-15 18:37:41 | Re: Strange phenomenon |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-10-15 19:51:02 | Re: UNION DISTINCT in doc |
| Previous Message | Dimitri Fontaine | 2010-10-15 19:15:23 | Re: Extensions, this time with a patch |