| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Nick Johnson <pgsql(at)spatula(dot)net> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #2690: GRANT does not allow periods in database or schema names |
| Date: | 2006-10-13 20:23:20 |
| Message-ID: | 20061013202320.GM23291@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Nick Johnson wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2690
> Logged by: Nick Johnson
> Email address: pgsql(at)spatula(dot)net
> PostgreSQL version: 8.1.1
> Operating system: FreeBSD 6.1
> Description: GRANT does not allow periods in database or schema names
> Details:
>
> 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.
Sure you can. Just quote the name:
GRANT ALL ON DATABASE "example.com" TO someuser;
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2006-10-13 20:33:29 | Re: BUG #2690: GRANT does not allow periods in database or schema names |
| Previous Message | Tom Lane | 2006-10-13 14:22:37 | Re: BUG #2692: psql sends natively-localized strings to database without setting client_encoding first |