Prepared statement invalidation - Mailing list pgsql-novice

From Daniel Heath
Subject Prepared statement invalidation
Date
Msg-id eae3cfcd-fe79-4516-b0ff-3872f2880943@www.fastmail.com
Whole thread Raw
Responses Re: Prepared statement invalidation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi All,

I'm running a site that has a reasonable amount of traffic 24/7 , writes and reads.

I've found that when I add a new column, I sometimes get a spike of errors on the application side due to prepared
statementquery plans getting invalidated, causing transactions to rollback.
 

The error is:

ERROR: cached plan must not change result type 

Is there a way to make postgres recalculate the query plan instead of failing the transaction when a new column is
added?

Thanks,
Daniel Heath



pgsql-novice by date:

Previous
From: Bzzzz
Date:
Subject: Re: Advice on foreign key and cascading delete design - postgresql 12.6
Next
From: Tom Lane
Date:
Subject: Re: Prepared statement invalidation