On 21 June 2011 20:48, Peter Eisentraut <peter_e@gmx.net> wrote:
> On tis, 2011-06-21 at 19:57 +0100, Thom Brown wrote:
>> According to the docs
>> (http://www.postgresql.org/docs/9.1/static/unsupported-features-sql-standard.html),
>> PostgreSQL doesn't support feature set E081 of the SQL:2008 standard,
>> which includes:
>>
>> E081-01 SELECT privilege at the table level
>> E081-02 DELETE privilege
>> E081-03 INSERT privilege at the table level
>> E081-04 UPDATE privilege at the table level
>> E081-05 UPDATE privilege at the column level
>> E081-06 REFERENCES privilege at the table level
>> E081-07 REFERENCES privilege at the column level
>> E081-08 WITH GRANT OPTION
>> E081-09 USAGE privilege
>> E081-10 EXECUTE privilege
>>
>> Am I mistaken, but aren't all of these supported?
>
> The USAGE privilege is not fully supported.
Okay, so it only says E081 because there's part of it that it doesn't
conform with? Now that I see the rest listed in the supported list
it's kind of obvious.
Thanks
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company