Re: Read-only connection mode for AI workflows. - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Read-only connection mode for AI workflows.
Date
Msg-id CAFj8pRC43My_CwC8e4S+b3R6XNviK75A=q-_utoQTwABegxx1Q@mail.gmail.com
Whole thread
In response to Re: Read-only connection mode for AI workflows.  (Andrei Lepikhov <lepihov@gmail.com>)
List pgsql-hackers
Hi

čt 19. 3. 2026 v 9:40 odesílatel Andrei Lepikhov <lepihov@gmail.com> napsal:
On 19/3/26 08:53, Pavel Stehule wrote:
>     We could improve it by restricting manual calls to specific utility
>     operations, such as VACUUM or REINDEX. However, we would need some
>     specifications first.
>
>
> It doesn't cover  possibility to set GUC by set_config function

Can you explain it? I added a test for the set_config() call.
This extension is so tiny because it exploits the rule: no ro -> rw
switch after a snapshot has been taken (but rw -> ro is possible). The
set_config can’t overcome this rule.

I am sorry. I missed so you used standard_ExecutorStart

Regards

Pavel
 

--
regards, Andrei Lepikhov,
pgEdge

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Feature freeze timezone change request
Next
From: "Greg Burd"
Date:
Subject: Re: another autovacuum scheduling thread