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

Ok, using "Inflight" instead of Inflight sems to work, except the user
luser still doesn't have any privileges.

grant all on database "Inflight" to luser;

returns:

    GRANT

But if I then "psql Inflight luser", I can't do anything including
simple selects against the Inflight database.


Travis Hume wrote:

> 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.
>>
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>