Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C7DCEB5DBE2 for ; Tue, 21 Jun 2011 16:48:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 60218-02 for ; Tue, 21 Jun 2011 19:48:27 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailout-de.gmx.net (mailout-de.gmx.net [213.165.64.22]) by mail.postgresql.org (Postfix) with SMTP id CC7A1B5D94C for ; Tue, 21 Jun 2011 16:48:26 -0300 (ADT) Received: (qmail invoked by alias); 21 Jun 2011 19:48:25 -0000 Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.101]) [88.115.218.165] by mail.gmx.net (mp072) with SMTP; 21 Jun 2011 21:48:25 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1/nneIivF3n5cWu7eajaVLUYhz3OTl9hMWHzpIGOh RzCY1yvxV2XOwY Subject: Re: SQL:2008 unsupported features From: Peter Eisentraut To: Thom Brown Cc: pgsql-docs In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Date: Tue, 21 Jun 2011 22:48:20 +0300 Message-ID: <1308685700.1713.0.camel@vanquo.pezone.net> Mime-Version: 1.0 X-Mailer: Evolution 2.32.3 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201106/85 X-Sequence-Number: 6859 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.