Re: Aren't regex_*() functions built-in?

[Christophe Pettus]

> On Nov 11, 2023, at 17:20, p...@pfortin.com wrote:
> Actually, it's more eusbtle...  I can make it work as "postgres"; but not
> as a RO user (SELECT only):
> An error occurred when executing the SQL command:
> select * from a,b where regexp_replace(a.address,' ','','g') = 
> regexp_replace(b.address,' ','','g')
> 
> ERROR: permission denied for table a
> 1 statement failed.
> 
> I had no idea functions need permissions... GRANT EXTENSION..?

The permission error isn't on the function, but on the table "a".  The RO user 
doesn't have the appropriate permissions on it.