Connection in read-only mode

[rac021]

Hi,

Is there a way to put the connection in read-only mode ?

Thank's

[BillyYccc]

What is connection read-only mode in Postgres? Do you mean read-only transactions(https://www.postgresql.org/docs/current/sql-set-transaction.html)?

[rac021]

Yes, this is what I mean

[BillyYccc]

Have you tried scheduling a query to control it directly?

[rac021]

What I am currently doing is adding "SET TRANSACTION READ ONLY" for each Sql query.
I want to do this using the client API. Is it possible ?

Thank's

[BillyYccc]

There's no specific API for this, I wonder does it make any difference between calling such an API and a query :-)

[rac021]

I mean , open transations in read only mode using reactive-pg-client ;-)

[BillyYccc]

I agreed we could add such APIs for the transactions characteristics, you can check the eclipse-vertx/vertx-sql-client#432

[rac021]

It would be interesting ( at least for me :-) )

Thank you