Fwd: Have a problem with citext

Started by David E. Wheelerover 8 years ago3 messages
#1David E. Wheeler
david@justatheory.com

Hackers,

Are permissions correct in the citext extension?

Best,

David

Show quoted text

Begin forwarded message:

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

#2Robert Haas
robertmhaas@gmail.com
In reply to: David E. Wheeler (#1)
Re: Fwd: Have a problem with citext

On Fri, Sep 29, 2017 at 6:16 PM, David E. Wheeler <david@justatheory.com> wrote:

Are permissions correct in the citext extension?

Not to be picky, but couldn't you investigate that a bit before posting here?

Off-hand, I see no GRANT or REVOKE statements in any of the citext SQL
files, so I'm going to guess that this is an artifact of some general
PostgreSQL behavior rather than anything specific to citext.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#3David E. Wheeler
david@justatheory.com
In reply to: Robert Haas (#2)
Re: Fwd: Have a problem with citext

On Oct 1, 2017, at 20:22, Robert Haas <robertmhaas@gmail.com> wrote:

Are permissions correct in the citext extension?

Not to be picky, but couldn't you investigate that a bit before posting here?

Normally I would, but my attention is far from Postgres these days, sadly, and I tend to think of citext (IT’S NOT SPELLED “CUTEST”, SIRI!) as part of the core, now, and I have forgotten more than I think I ever knew about it. Sorry.

D