Re: Running a Simple Update Statement Fails, Second Time Suceeds. - Mailing list pgsql-general

From Tom Lane
Subject Re: Running a Simple Update Statement Fails, Second Time Suceeds.
Date
Msg-id 3000.1567610238@sss.pgh.pa.us
Whole thread Raw
In response to RE: Running a Simple Update Statement Fails, Second Time Suceeds.  ("Kumar, Virendra" <Virendra.Kumar@guycarp.com>)
Responses RE: Running a Simple Update Statement Fails, Second Time Suceeds.
List pgsql-general
"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



pgsql-general by date:

Previous
From: Jason Ralph
Date:
Subject: PG11.2 - wal_level =minimal max_wal_senders = 0
Next
From: Luca Ferrari
Date:
Subject: Re: PG11.2 - wal_level =minimal max_wal_senders = 0