| 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: | Whole Thread | Raw Message | 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 |