SQL:2008 unsupported features

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.

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