WITH inconsistency

From: Robert Grabowski <grabbai(at)7bulls(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: WITH inconsistency
Date: 2009-04-19 22:35:25
Message-ID: 200904200035.25331.grabbai@7bulls.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-04-19 22:38:33 Re: [PATCH] Borland C Compiler compatibility issues
Previous Message Tom Lane 2009-04-19 21:51:55 Re: Sigh, MSVC build broken again