![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Description: Problem with capitalised DB names... Details: When trying to grant database privileges to a group of users there is no way to do this if the database name is capitalised (i.e. db-name = Test). The error message when performing the grant operation: grant all on DATABASE test to group tgroup; is: ERROR: database "test" does not exist I have used capitalisation an a number of databases, so this now seems to require me to rename them all in to lower-case... |
#3
| |||
| |||
|
|
Thanks... (maybe include this in the manuals, I couldn't find this information...) |
#4
| |||
| |||
|
|
On Tue, Apr 05, 2005 at 18:09:25 +0100, "Marcus v. Scotti" <m.scotti (AT) fry-it (DOT) com> wrote: Description: Problem with capitalised DB names... Details: When trying to grant database privileges to a group of users there is no way to do this if the database name is capitalised (i.e. db-name = Test). The error message when performing the grant operation: grant all on DATABASE test to group tgroup; is: ERROR: database "test" does not exist I have used capitalisation an a number of databases, so this now seems to require me to rename them all in to lower-case... You need to use double quotes (") around database, table or column names that are not all lowercase. |
#5
| |||
| |||
|
|
On Mon, Apr 11, 2005 at 09:37:08 +0100, "Marcus v. Scotti" <mvscotti (AT) gmail (DOT) com> wrote: Thanks... (maybe include this in the manuals, I couldn't find this information...) It is: http://developer.postgresql.org/docs...AX-IDENTIFIERS |
![]() |
| Thread Tools | |
| Display Modes | |
| |