On Tue, Apr 05, 2005 at 18:09:25 +0100,
  "Marcus v. Scotti" <[EMAIL PROTECTED]> 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.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to