WITH inconsistency

Started by Robert Grabowskialmost 17 years ago2 messageshackers
Jump to latest
#1Robert Grabowski
grabbai@7bulls.com

Hi,

I found some inconsistency on WITH keyword:

1) => \h CREATE TABLE

[...]
[ WITH ( storage_parameter [= value] [, ... ] ) ]
[...]

"=" is required

2) => \h CREATE ROLE

Command: CREATE ROLE
Description: define a new database role
Syntax:
CREATE ROLE name [ [ WITH ] option [ ... ] ]

where option can be:

SUPERUSER | NOSUPERUSER
[...]
| IN ROLE rolename [, ...]
| IN GROUP rolename [, ...]
| ROLE rolename [, ...]
| ADMIN rolename [, ...]
| USER rolename [, ...]
| SYSID uid

"=" is not available

3) => \h CREATE DATABASE
Command: CREATE DATABASE
Description: create a new database
Syntax:
CREATE DATABASE name
[ [ WITH ] [ OWNER [=] dbowner ]
[ TEMPLATE [=] template ]
[ ENCODING [=] encoding ]
[ LC_COLLATE [=] lc_collate ]
[ LC_CTYPE [=] lc_ctype ]
[ TABLESPACE [=] tablespace ]
[ CONNECTION LIMIT [=] connlimit ] ]

"=" is optional

Cheers,
Robert

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Robert Grabowski (#1)
Re: WITH inconsistency

On Monday 20 April 2009 01:35:25 Robert Grabowski wrote:

I found some inconsistency on WITH keyword:

Yes, there are lots of those. Deal with it. ;-)