Re: Error: "remote query result rowtype does not match the specifiedFROM clause rowtype," on remote function call - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Error: "remote query result rowtype does not match the specifiedFROM clause rowtype," on remote function call
Date
Msg-id bf394d3b-d6a7-95cd-7fa8-4ef213b4e2dc@aklaver.com
Whole thread Raw
In response to Re: Error: "remote query result rowtype does not match the specifiedFROM clause rowtype," on remote function call  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Error: "remote query result rowtype does not match the specifiedFROM clause rowtype," on remote function call
Next
From: Rob Sargent
Date:
Subject: stale WAL files?