Just got confirmation from developer that they are not modifying any type.
We are on 11.5 RHEL.
Regards,
Virendra
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, September 04, 2019 11:17 AM
To: Kumar, Virendra
Cc: Adrian Klaver; pgsql-general@lists.postgresql.org
Subject: Re: Running a Simple Update Statement Fails, Second Time Suceeds.
"Kumar, Virendra" <Virendra.Kumar@guycarp.com> writes:
> Here is function code:
Hm, nothing very exciting in there. But the known reasons for this
type of error involve something changing a table rowtype that the
function uses (that is, ALTER TABLE ADD COLUMN or the like). Or
dropping/recreating such a table altogether. Is there any part
of your workflow that redefines the type of
product_owner.external_sys_class_code_pres.audit_update_dt or
product_owner.external_sys_class_code_pres ?
Also, you still didn't tell us the server's version.
regards, tom lane
________________________________
This message is intended only for the use of the addressee and may contain
information that is PRIVILEGED AND CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please erase all copies of the message
and its attachments and notify the sender immediately. Thank you.
