Fwd: Have a problem with citext

Hackers,

Are permissions correct in the citext extension?

Best,

David

> Begin forwarded message:
>
> From: Sadek Touati <bilal2dellys(at)hotmail(dot)com>
> Subject: Have a problem with citext
> Date: September 29, 2017 at 17:02:50 EDT
> To: "david(at)kineticode(dot)com" <david(at)kineticode(dot)com>
>
> 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