Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id EF214B5DBCB for ; Tue, 21 Jun 2011 16:55:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 63645-06 for ; Tue, 21 Jun 2011 19:55:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp1.linux-foundation.org (smtp1.linux-foundation.org [140.211.169.13]) by mail.postgresql.org (Postfix) with ESMTP id 5CE0BB5D94C for ; Tue, 21 Jun 2011 16:55:41 -0300 (ADT) Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) (authenticated bits=0) by smtp1.linux-foundation.org (8.14.2/8.13.5/Debian-3ubuntu1.1) with ESMTP id p5LJtc7E012452 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=FAIL) for ; Tue, 21 Jun 2011 12:55:39 -0700 Received: by wyb38 with SMTP id 38so85277wyb.19 for ; Tue, 21 Jun 2011 12:55:38 -0700 (PDT) Received: by 10.216.202.79 with SMTP id c57mr1249466weo.21.1308686138098; Tue, 21 Jun 2011 12:55:38 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.45.199 with HTTP; Tue, 21 Jun 2011 12:55:08 -0700 (PDT) In-Reply-To: <1308685700.1713.0.camel@vanquo.pezone.net> References: <1308685700.1713.0.camel@vanquo.pezone.net> From: Thom Brown Date: Tue, 21 Jun 2011 20:55:08 +0100 Message-ID: Subject: Re: SQL:2008 unsupported features To: Peter Eisentraut Cc: pgsql-docs Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-MIMEDefang-Filter: lf$Revision: 1.188 $ X-Scanned-By: MIMEDefang 2.63 on 140.211.169.13 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201106/86 X-Sequence-Number: 6860 On 21 June 2011 20:48, Peter Eisentraut 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-stan= dard.html), >> PostgreSQL doesn't support feature set E081 of the SQL:2008 standard, >> which includes: >> >> E081-01 =A0 =A0 =A0 SELECT privilege at the table level >> E081-02 =A0 =A0 =A0 DELETE privilege >> E081-03 =A0 =A0 =A0 INSERT privilege at the table level >> E081-04 =A0 =A0 =A0 UPDATE privilege at the table level >> E081-05 =A0 =A0 =A0 UPDATE privilege at the column level >> E081-06 =A0 =A0 =A0 REFERENCES privilege at the table level >> E081-07 =A0 =A0 =A0 REFERENCES privilege at the column level >> E081-08 =A0 =A0 =A0 WITH GRANT OPTION >> E081-09 =A0 =A0 =A0 USAGE privilege >> E081-10 =A0 =A0 =A0 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 --=20 Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company