Postgresql throws 'ERROR: cached plan must not change result type' exceptions when the meta data of a sql statements changes. e.g. an ALTER TABLE command was executed on the underlying table of the prepared statement.
Currently Sqlg executes deallocate all and resets the pool to deal with this scenario.
Setting autosave=conservative on the driver will take care of this at the driver level.
Postgresql throws 'ERROR: cached plan must not change result type' exceptions when the meta data of a sql statements changes. e.g. an
ALTER TABLEcommand was executed on the underlying table of the prepared statement.Currently Sqlg executes
deallocate alland resets the pool to deal with this scenario. Settingautosave=conservativeon the driver will take care of this at the driver level.