Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16436: Functions with input parameter table type failingfrom application - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: BUG #16436: Functions with input parameter table type failingfrom application
Date
Msg-id CAFj8pRAV3kXhU0L2A+W-ocDQnQoOoYdYdRzX5e4fSax1nA=CGQ@mail.gmail.com
Whole thread Raw
In response to BUG #16436: Functions with input parameter table type failing from application  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view


čt 14. 5. 2020 v 9:01 odesílatel PG Bug reporting form <noreply@postgresql.org> napsal:
The following bug has been logged on the website:

Bug reference:      16436
Logged by:          spandana reddy
Email address:      banaspandana4@gmail.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 !!

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Multi-parent inherited table with mixed storage options cannot berestored
Next
From: Tom Lane
Date:
Subject: Re: Re:BUG #16434: some data lost