Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id ABCA6B5DBDC for ; Tue, 21 Jun 2011 15:58:06 -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 13526-09 for ; Tue, 21 Jun 2011 18:58:00 +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 27A8CB5DBD8 for ; Tue, 21 Jun 2011 15:57:59 -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 p5LIvuUp006707 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=FAIL) for ; Tue, 21 Jun 2011 11:57:58 -0700 Received: by wyb38 with SMTP id 38so49449wyb.19 for ; Tue, 21 Jun 2011 11:57:56 -0700 (PDT) Received: by 10.216.197.96 with SMTP id s74mr3211769wen.21.1308682676250; Tue, 21 Jun 2011 11:57:56 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.45.199 with HTTP; Tue, 21 Jun 2011 11:57:26 -0700 (PDT) From: Thom Brown Date: Tue, 21 Jun 2011 19:57:26 +0100 Message-ID: Subject: SQL:2008 unsupported features To: pgsql-docs Content-Type: text/plain; charset=ISO-8859-1 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/84 X-Sequence-Number: 6858 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? -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company