pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #16436: Functions with input parameter table type failing from application 2+ messages / 2 participants [nested] [flat]
* BUG #16436: Functions with input parameter table type failing from application @ 2020-05-14 05:38 PG Bug reporting form <noreply@postgresql.org> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2020-05-14 05:38 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: banaspandana4@gmail.com 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 Thanks !! ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #16436: Functions with input parameter table type failing from application @ 2020-05-14 11:12 Pavel Stehule <pavel.stehule@gmail.com> parent: PG Bug reporting form <noreply@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Pavel Stehule @ 2020-05-14 11:12 UTC (permalink / raw) To: banaspandana4@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org> č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 !! > > ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-05-14 11:12 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2020-05-14 05:38 BUG #16436: Functions with input parameter table type failing from application PG Bug reporting form <noreply@postgresql.org> 2020-05-14 11:12 ` Pavel Stehule <pavel.stehule@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox