Re: WITH CHECK and Column-Level Privileges - Mailing list pgsql-hackers

From Robert Haas
Subject Re: WITH CHECK and Column-Level Privileges
Date
Msg-id CA+TgmoZO-9jHu9FM_=xPt+2HLUzcmL=waw8qDBAe-zcb+ijcBQ@mail.gmail.com
Whole thread Raw
In response to Re: WITH CHECK and Column-Level Privileges  (Stephen Frost <sfrost@snowman.net>)
Responses Re: WITH CHECK and Column-Level Privileges
List pgsql-hackers
On Wed, Oct 29, 2014 at 8:16 AM, Stephen Frost <sfrost@snowman.net> wrote:
> suggestions.  If the user does not have table-level SELECT rights,
> they'll see for the "Failing row contains" case, they'll get:
>
> Failing row contains (col1, col2, col3) = (1, 2, 3).
>
> Or, if they have no access to any columns:
>
> Failing row contains () = ()

I haven't looked at the code, but that sounds nice, except that if
they have no access to any columns, I'd leave the message out
altogether instead of emitting it with no useful content.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: TAP test breakage on MacOS X
Next
From: Robert Haas
Date:
Subject: Re: Directory/File Access Permissions for COPY and Generic File Access Functions