Re: BUG #2690: GRANT does not allow periods in database or schema names

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Cc: "Nick Johnson" <pgsql(at)spatula(dot)net>
Subject: Re: BUG #2690: GRANT does not allow periods in database or schema names
Date: 2006-10-13 20:33:29
Message-ID: 200610132233.29481.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-10-13 20:35:42 Re: BUG #2690: GRANT does not allow periods in database or schema names
Previous Message Alvaro Herrera 2006-10-13 20:23:20 Re: BUG #2690: GRANT does not allow periods in database or schema names