enso icon indicating copy to clipboard operation
enso copied to clipboard

Ability to open a read-only Postgres connection

Open radeusgd opened this issue 4 months ago • 0 comments

Add a flag to Postgres.Server constructor specifying to open a connection in read-only mode.

It should:

  • block operations that modify data by a dialect flag, returning user-friendly errors,
  • set a setting on the JDBC connection to disallow modifications in custom queries.

Should creating and modifying temporary tables be allowed? In the first iteration probably not, but overall it might be useful.

Once #9732 are implemented, the data link will delegate the read-only status to this connection flag.

radeusgd avatar Oct 10 '24 14:10 radeusgd