Re: Error: "remote query result rowtype does not match the specified FROM clause rowtype," on remote function call

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Antonio Gomez <AGomez(at)EBSCO(dot)COM>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Error: "remote query result rowtype does not match the specified FROM clause rowtype," on remote function call
Date: 2019-03-25 22:48:24
Message-ID: bf394d3b-d6a7-95cd-7fa8-4ef213b4e2dc@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/25/19 3:26 PM, Adrian Klaver wrote:
> On 3/25/19 3:20 PM, Antonio Gomez wrote:

> select * from public._test1();
> ERROR:  a column definition list is required for functions returning
> "record"
> LINE 1: select * from public._test1();
>
> Have you looked at postresql_fdw?:

Sorry was not thinking. postgresql_fdw works on tables/views, it would
not help in your situation.

>
> https://www.postgresql.org/docs/11/postgres-fdw.html
>
>>
>> Thanks for your response!
>>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2019-03-26 00:10:09 stale WAL files?
Previous Message Adrian Klaver 2019-03-25 22:26:08 Re: Error: "remote query result rowtype does not match the specified FROM clause rowtype," on remote function call