Hackers, Are permissions correct in the citext extension?
Best, David > Begin forwarded message: > > From: Sadek Touati <bilal2del...@hotmail.com> > Subject: Have a problem with citext > Date: September 29, 2017 at 17:02:50 EDT > To: "da...@kineticode.com" <da...@kineticode.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
signature.asc
Description: Message signed with OpenPGP