Case sensitive grant statements in pg14?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello all, 

Just ran across a really strange thing in a PostgreSQL 14 database.  Apparently grant statements are now somehow case sensitive.

ex:
grant create, usage on schema {schema_name} to {role};

fails with the error:
ERROR: syntax error at or near "{role}"

but by changing the capitalization of the statement to:
GRANT CREATE, USAGE ON SCHEMA {schema_name} TO {role};

completes successfully.

Is this something new?

Thanks,
rik.


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux