Re: BUG #2690: GRANT does not allow periods in database or schema names - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #2690: GRANT does not allow periods in database or schema names
Date
Msg-id 200610132233.29481.peter_e@gmx.net
Whole thread Raw
In response to BUG #2690: GRANT does not allow periods in database or schema names  ("Nick Johnson" <pgsql@spatula.net>)
List pgsql-bugs
Nick Johnson wrote:
> Though you can create a database with a period in the name (e.g.,
> "example.com"), you cannot issue a GRANT on that database name from
> the command line.
>
> pgsql=# GRANT ALL ON DATABASE example.com TO someuser;
> ERROR:  syntax error at or near "." at character 30

You are making the faulty assumption that example.com and "example.com"
are the same thing.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #2690: GRANT does not allow periods in database or schema names
Next
From: Tom Lane
Date:
Subject: Re: BUG #2690: GRANT does not allow periods in database or schema names