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