"Kumar, Virendra" writes:
> Just got confirmation from developer that they are not modifying any type.
> We are on 11.5 RHEL.
Interesting. Can you exhibit a self-contained test case?
regards, tom lane
On 9/4/19 8:02 AM, Kumar, Virendra wrote:
Here is function code:
Table definition is below:
--
product_master_fdw=# \d product_owner.external_sys_class_code_pres;
Table "product_owner.external_sys_class_code_pres"
Column|Type
"Kumar, Virendra" 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. I
s_id" FOREIGN KEY (pres_id) REFERENCES
product_owner.external_sys_class_code_pres(pres_id) DEFERRABLE
TABLE "product_owner.external_prod_dtl_presd" CONSTRAINT "presd_fk_pres_id"
FOREIGN KEY (pres_id) REFERENCES
product_owner.external_sys_class_code_pres(pres_id) DEFERRABLE
R
Hi Tom,
Sincere apologies for that privacy notice in email, this company policy which I
cannot skip.
Adrian,
The function is really simple. I’ll share the code as soon as I can.
Regards,
Virendra
> On Sep 3, 2019, at 5:41 PM, Tom Lane wrote:
>
> Adrian Klaver writes:
>>> On 9/3/19 1:56 PM,
Adrian Klaver writes:
> On 9/3/19 1:56 PM, Kumar, Virendra wrote:
>> Here is simple query, I am running via function call. This statement
>> runs fine as SQL but when put in function as plpgsql it failes with
>> error below, when I ran second times in same session it succeeds:
> We will need to
On 9/3/19 1:56 PM, Kumar, Virendra wrote:
Here is simple query, I am running via function call. This statement
runs fine as SQL but when put in function as plpgsql it failes with
error below, when I ran second times in same session it succeeds:
We will need to see the function definition.
-
Type ID doesn't seem to be existing:
product_master_fdw=> select * from pg_type where oid=196609;
typname | typnamespace | typowner | typlen | typbyval | typtype | typcategory |
typispreferred | typisdefined | typdelim | typrelid | typelem | typarray |
typinput | typoutput | typreceive | t
ypsen
