Error: "cached plan must not change result type"
Dear Members!
At Friday one of our clients got this error:
"cached plan must not change result type"
He restarted the application and the problem vanished.
We used PGDAC to access the database.
Firstly we didn't know nothing about this kind of error.
But later we realized that somebody in our company altered a very often
used table.
He added only one field with default value while they were using the
programme (they didn't exit).
Just for we will be sure: these modifications could generate this kind of
error?
What is the complete description of this error? What we need to not do for
avoid it?
Thank you!
Best Regards
dd
On 9 Oct 2017 13:13, "Durumdara" <durumdara@gmail.com> wrote:
"cached plan must not change result type"
As far as I remember, this kind of errors you can get from a prepared
statement execution, when the result type of it was changed (as in your
case by adding a column to a table that provides the data for a prepared
statement).