Re: Does has_table_privilege() have a case bug - Mailing list pgsql-general

On Tue, 2008-02-05 at 16:10 -0800, johnf wrote:
> I create a table named "Account_Text_Table" the owner is 'johnf'.
>
> select has_table_privilege('johnf', 'public.Account_Text_Table', 'SELECT')
> I get the following error:
>
> ERROR:  relation "public.account_text_table" does not exist

PostgreSQL folds to lower case unless you put the name in double-quotes.
Try putting the table name in double-quotes.

E.g.: select has_table_privilege('johnf', 'public."Account_Text_Table"',
'SELECT')

Regards,
    Jeff Davis