[MASSMAIL]cached plan must not change result type - Mailing list pgsql-admin

From James Pang
Subject [MASSMAIL]cached plan must not change result type
Date
Msg-id CAHgTRfcg2jGnjSqq1NVuMDtCjRU3aOXWrhXn1L=92Ka_Ug6euw@mail.gmail.com
Whole thread Raw
Responses Re: cached plan must not change result type
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: Like to RETURN SQL results set
Next
From: M Sarwar
Date:
Subject: Re: Like to RETURN SQL results set