public inbox for [email protected]help / color / mirror / Atom feed
SQL:2008 unsupported features 3+ messages / 2 participants [nested] [flat]
* SQL:2008 unsupported features @ 2011-06-21 18:57 Thom Brown <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Thom Brown @ 2011-06-21 18:57 UTC (permalink / raw) To: pgsql-docs 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SQL:2008 unsupported features @ 2011-06-21 19:48 Peter Eisentraut <[email protected]> parent: Thom Brown <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Peter Eisentraut @ 2011-06-21 19:48 UTC (permalink / raw) To: Thom Brown <[email protected]>; +Cc: pgsql-docs 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SQL:2008 unsupported features @ 2011-06-21 19:55 Thom Brown <[email protected]> parent: Peter Eisentraut <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Thom Brown @ 2011-06-21 19:55 UTC (permalink / raw) To: Peter Eisentraut <[email protected]>; +Cc: pgsql-docs On 21 June 2011 20:48, Peter Eisentraut <[email protected]> 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-06-21 19:55 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-06-21 18:57 SQL:2008 unsupported features Thom Brown <[email protected]> 2011-06-21 19:48 ` Peter Eisentraut <[email protected]> 2011-06-21 19:55 ` Thom Brown <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox