Run doctests and update tests on PostgreSQL 15

[syvb]

Currently TimescaleDB doesn't support PostgreSQL 15, which our update tests and doctests rely on. When a TimescaleDB release with PostgreSQL 15 support comes out, we should reenable these tests in CI.

see: #646