Re: can't "grant all on database..."

From: Travis Hume <travis(dot)hume(at)tenzing(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: can't "grant all on database..."
Date: 2003-06-18 18:17:50
Message-ID: 3EF0ACCE.6070006@tenzing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The dbname is "Inflight", and I did think it was strange the the error
msg called it "inflight".
What is this "case folding of unquoted names" you speak of? Do I need
to quote my dbname? Anything else?

Thanks for quick reply.

Stephan Szabo wrote:

>On Wed, 18 Jun 2003, Travis Hume wrote:
>
>
>
>>I've created a database called Inflight as user fc
>>I've created a user named luser
>>
>>I want to:
>>
>> grant all on database Inflight to luser;
>>
>>and PostgreSQL responds:
>>
>> ERROR: database "inflight" not found
>>
>>
>
>Is the database inflight or "Inflight"? You're probably being
>bitten by the case folding of unquoted names.
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Travis Hume 2003-06-18 18:23:44 Re: can't "grant all on database..."
Previous Message Jonathan Bartlett 2003-06-18 18:07:12 Re: PostgreSQL alternative to "Oracle Real Application