WITH inconsistency
| От | Robert Grabowski |
|---|---|
| Тема | WITH inconsistency |
| Дата | |
| Msg-id | 200904200035.25331.grabbai@7bulls.com обсуждение исходный текст |
| Ответы |
Re: WITH inconsistency
|
| Список | 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
В списке pgsql-hackers по дате отправления: