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
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 |