Re: TRUNCATE privilege vs information_schema

On Sun, Sep 7, 2008 at 9:52 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Whilst going through the pending patch to add TRUNCATE as a separate
> permission, I noticed that it neglected to add TRUNCATE to the various
> columns in information_schema that display privileges. I wonder whether
> we should do so, or whether we should restrict information_schema to
> only show SQL-spec-compatible privileges.

If we add that, how many other places are we likely to creep from the
spec in the future? I think we should keep it as spec-compliant as
possible.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com