-
Notifications
You must be signed in to change notification settings - Fork 4.1k
CREATE SCHEMA... AUTHORIZATION is unsupported #53559
Copy link
Copy link
Closed
Description
In Postgres,
postgres=# create user andy;
CREATE ROLE
postgres=# CREATE SCHEMA AUTHORIZATION andy;
CREATE SCHEMA
postgres=# CREATE SCHEMA andy_schema AUTHORIZATION andy;
CREATE SCHEMA
postgres=# \dn
List of schemas
Name | Owner
-------------+----------
andy | andy
andy_schema | andy
public | postgres
(3 rows)
In CockroachDB,
root@127.0.0.1:63916/vy> CREATE SCHEMA AUTHORIZATION andy;
invalid syntax: statement ignored: at or near "andy": syntax error
SQLSTATE: 42601
DETAIL: source SQL:
CREATE SCHEMA AUTHORIZATION andy
^
root@127.0.0.1:63916/vy> CREATE SCHEMA andy_schema AUTHORIZATION andy;
invalid syntax: statement ignored: at or near "authorization": syntax error
SQLSTATE: 42601
DETAIL: source SQL:
CREATE SCHEMA andy_schema AUTHORIZATION andy
^
We should at least return an unimplemented error
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels