Error: "cached plan must not change result type"

From: Durumdara <durumdara(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Error: "cached plan must not change result type"
Date: 2017-10-09 11:12:29
Message-ID: CAEcMXhmmRd4-+NQbnjDT26XNdUoXdmntV9zdr8=Tu8PL9aVCYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2017-10-09 13:40:46 Using cp to back up a database?
Previous Message David Rowley 2017-10-09 10:47:59 Re: Equivalence Classes when using IN