Обсуждение: [GENERAL] Error: "cached plan must not change result type"

Поиск
Список
Период
Сортировка

[GENERAL] Error: "cached plan must not change result type"

От
Durumdara
Дата:
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



Re: [GENERAL] Error: "cached plan must not change result type"

От
Dmitry Dolgov
Дата:
>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).