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

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.
>
>
>