public inbox for [email protected]
help / color / mirror / Atom feedSQL:2008 unsupported features
3+ messages / 2 participants
[nested] [flat]
* SQL:2008 unsupported features
@ 2011-06-21 18:57 Thom Brown <[email protected]>
2011-06-21 19:48 ` Re: SQL:2008 unsupported features Peter Eisentraut <[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 18:57 SQL:2008 unsupported features Thom Brown <[email protected]>
@ 2011-06-21 19:48 ` Peter Eisentraut <[email protected]>
2011-06-21 19:55 ` Re: SQL:2008 unsupported features 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 18:57 SQL:2008 unsupported features Thom Brown <[email protected]>
2011-06-21 19:48 ` Re: SQL:2008 unsupported features Peter Eisentraut <[email protected]>
@ 2011-06-21 19:55 ` Thom Brown <[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