Re: [GENERAL] Does has_table_privilege() have a case bug

On Tuesday 05 February 2008 04:40:18 pm brian wrote: > Jeff Davis wrote: > > 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 fol

Re: [GENERAL] Does has_table_privilege() have a case bug

Jeff Davis wrote: 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

Re: [GENERAL] Does has_table_privilege() have a case bug

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 PostgreS

[GENERAL] Does has_table_privilege() have a case bug

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 SUSE 10.3 Postgres 8.1.9 -- John Fabiani -