title: Cached plan must not change result type
body: <p>Our service team is getting the error <em>Cached plan must not change result type</em> sometimes when I modify the length of a column or add a new column in the table.</p>
  
  <p>I tried solutions mentioned on Stack Overflow like <a href="https://stackoverflow.com/questions/2783813/postgres-error-cached-plan-must-not-change-result-type">Postgres: &quot;ERROR: cached plan must not change result type&quot;</a></p>
  
  <p>I have tried <code>autosave=conservative</code> to resolve this issue but still, I am able to reproduce this issue. I used below JDBC connection string</p>
  
  <pre><code>jdbc-url: jdbc:postgresql://172.16.244.10:5432/testdb?autosave=conservative
  </code></pre>
  
  <p>why is this property not working in my case?</p>
  
  <p>Also, I tested with <code>prepareThreshold=0</code> and its working fine. But I think it will impact performance because it will never use client-side prepared statements.</p>
  
  <p>I just want to know the best solution to avoid this error.</p>