postgres_scanner

postgres_scanner copied to clipboard

I think it would make sense to have an option called pg_use_transaction that allows you to disable transactions.

For example, in this issue: https://github.com/duckdb/duckdb-postgres/issues/285 not having the option to disable transactions leads to VACUUM not being possible to execute in the attached postgres database.

It could also make sense for this to only affect postgres_query() and postgres_execute(), and not the storage extension part.

I would like to implement this.