Re: BUG #16436: Functions with input parameter table type failing from application

čt 14. 5. 2020 v 9:01 odesílatel PG Bug reporting form <
noreply(at)postgresql(dot)org> napsal:

> The following bug has been logged on the website:
>
> Bug reference: 16436
> Logged by: spandana reddy
> Email address: banaspandana4(at)gmail(dot)com
> PostgreSQL version: 10.10
> Operating system: Windows 10 Enterprise
> Description:
>
> Hi Team,
>
> Functions with input parameter as table type are getting failed from
> application where as working fine in PostgreSQL. We are facing the below
> error on one of our Client DB. After taking backup and restoring again
> resolved the issue but while creating new DB with existing DB as template
> has the same issue.
> Can you please help here ?
>
> Error:
> Message - 42804: wrong data type: 1043, expected 2950;
> 42804: wrong data type: 1043, expected 2950
>

This is not postgres's bug.

Maybe you should to use explicit cast

There is some wrong - this message say so target type should be uuid, but
input type is varchar

> Thanks !!
>
>