Dear sir,
I'm using the citext datatype in my application. I have PostgresSql 9.6 installed by EnterpriseDB
psql mydatabase postgres
create extension citext with schema myschema
\c mydatabase biguser
set search_path to myschema;
create table tst(v citext);
insert into tst values('sadek');
> select strpos(v, 'd') from tst;
ERROR: permission denied for function strpos
> select strpos(v, 'd'::citext) from tst; (If I read the documentation correctly this should work! alas, it doesn't)
ERROR: permission denied for function strpos
> select strpos(v::citext, 'd'::citext) from tst;
ERROR: permission denied for function strpos
> select strpos(v::citext, 'd') from tst;
ERROR: permission denied for function strpos
> select strpos(v::citext, 'd'::citext) from tst;
ERROR: permission denied for function strpos
> select strpos(v::text, 'd'::text) from tst;
strpos
--------
3
(1 row)
Am I missing something here?
thanks in advance