On Saturday, November 11, 2023, wrote:
>
> If EXECUTE is really supposed to be required; is it a bug that I
> finally got regexp_replace() to work...?
>
The PUBLIC pseudo-role is granted permission, at the time of the function’s
creation (i.e., as a default privilege) to execute all functions in
I need to follow my own advice: slow-down and you'll go faster...
Logged in as "postgres" (superuser). I see regexp_replace(); but not if
logged in as a read-only user...
So this is a permissions issue... I just discovered that a RO user with
only SELECT permision can run a query using regexp_re
On 11/11/23 17:20, p...@pfortin.com wrote:
On Sat, 11 Nov 2023 17:10:29 -0800 Adrian Klaver 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.
On Saturday, November 11, 2023, wrote:
>
> I had no idea functions need permissions... GRANT EXTENSION..?
>
You really need to get away from thinking anything you are doing has to do
with extensions. As you noted the function you found is in the core part
of the documentation so it isn’t an ext
> 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.
On Sat, 11 Nov 2023 17:10:29 -0800 Adrian Klaver wrote:
>On 11/11/23 17:04, p...@pfortin.com wrote:
>> On Sat, 11 Nov 2023 16:53:01 -0800 Adrian Klaver wrote:
>>
>>> On 11/11/23 16:25, p...@pfortin.com wrote:
>>> Reply to list also
>>> Ccing list
On Sat, 11 Nov 2023 16:16:20 -0800 Adrian
On 11/11/23 17:04, p...@pfortin.com wrote:
On Sat, 11 Nov 2023 16:53:01 -0800 Adrian Klaver wrote:
On 11/11/23 16:25, p...@pfortin.com wrote:
Reply to list also
Ccing list
On Sat, 11 Nov 2023 16:16:20 -0800 Adrian Klaver wrote:
Probably because it is spelled regexp_replace ().
OK, fo
On Sat, 11 Nov 2023 16:53:01 -0800 Adrian Klaver wrote:
>On 11/11/23 16:25, p...@pfortin.com wrote:
>Reply to list also
>Ccing list
>> On Sat, 11 Nov 2023 16:16:20 -0800 Adrian Klaver wrote:
>>
>
>>> Probably because it is spelled regexp_replace ().
>>
>> OK, found it in pg_catalog; but "cr
On 11/11/23 16:25, p...@pfortin.com wrote:
Reply to list also
Ccing list
On Sat, 11 Nov 2023 16:16:20 -0800 Adrian Klaver wrote:
Probably because it is spelled regexp_replace ().
OK, found it in pg_catalog; but "create extension regexp_replace;" won't
load it. How do I get regexp_* into pu
On 11/11/23 16:12, p...@pfortin.com wrote:
Hi,
PostgreSQL 15.4 on x86_64-mageia-linux-gnu, compiled by gcc (Mageia
12.3.0-3.mga9) 12.3.0, 64-bit
(the distro which can't figure out how to provide pgAdmin4)
Aren't all the functions listed in
https://www.postgresql.org/docs/current/functions-strin
On Saturday, November 11, 2023, wrote:
> Hi,
>
> PostgreSQL 15.4 on x86_64-mageia-linux-gnu, compiled by gcc (Mageia
> 12.3.0-3.mga9) 12.3.0, 64-bit
> (the distro which can't figure out how to provide pgAdmin4)
>
> Aren't all the functions listed in
> https://www.postgresql.org/docs/current/funct
Hi,
PostgreSQL 15.4 on x86_64-mageia-linux-gnu, compiled by gcc (Mageia
12.3.0-3.mga9) 12.3.0, 64-bit
(the distro which can't figure out how to provide pgAdmin4)
Aren't all the functions listed in
https://www.postgresql.org/docs/current/functions-string.html
assumed to be included in a base insta
12 matches
Mail list logo