docs: are Postgres transactions supported or not?

[SebAlbert]

What would you like help with?

I am considering to use ADBC and unsure as to whether transactions are supported with Postgres or not.
This page says N (nope): https://arrow.apache.org/adbc/current/driver/status.html#feature-support
This page explicitly states the opposite: https://arrow.apache.org/adbc/current/driver/postgresql.html#transactions

[CurtHagenlocher]

Transactions are supported via the autocommit connection option (adbc.connection.autocommit). Isolation levels do not appear to be supported.

Source reference

[lidavidm]

We need to update the docs here, sorry about the confusion.

[SebAlbert]

Thanks!

Regarding isolation levels, I don't see a reason in that code why they wouldn't be respected when I set them via SQL commands.

[lidavidm]

Correct, we don't really do anything one way or another, just that there are some standard options from the driver side meant to set them that the PostgreSQL driver does not recognize. If you directly set them via SQL the driver does not care either way. (This does not necessarily apply to transactions themselves, the driver may need to start/commit transactions at certain points for certain functionality so managing transactions yourself may lead to unexpected errors.)

[lidavidm]

Ah interesting, the actual problem is that the docs for 1.0.0 didn't upload properly...