hi,
PGV14, client use PGJDBC driver and prepared statements, when a table "alter table alter column type ..." changes done, a lot of JDBC clients got this error "cached plan must not change result type". when a JDBC client got this error first time after the DDL schema change, JDBC driver will clear this caching-plan and following same SQL statement got parsing again and new cached plan right?
How to avoid this issue when DDL schema changes ?
Thanks,
James