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

From Antonio Gomez
Subject Error: "remote query result rowtype does not match the specified FROMclause rowtype," on remote function call
Date
Msg-id BN7PR01MB365172F60FCCC2F1DBEAB873D65E0@BN7PR01MB3651.prod.exchangelabs.com
Whole thread Raw
Responses Re: Error: "remote query result rowtype does not match the specifiedFROM clause rowtype," on remote function call
List pgsql-general

This is my remote function:

CREATE OR REPLACE FUNCTION public._test1()

RETURNS record

LANGUAGE plpgsql

AS $function$

DECLARE

rec record;

BEGIN

  select 1,2 into rec;

  return rec;

END $function$;

 

This is my local function call:

SELECT x.a, x.b

FROM dblink('conn_str', 'select public._test1();')

as x(a int ,b int);

 

This is the error thrown:

ERROR: remote query result rowtype does not match the specified FROM clause rowtype

 

Question:

Since DBLINK requires that I define a schema to place the function's return items, how do I make the call to recognize a record type being returned by the function.

 

Thanks!

 

pgsql-general by date:

Previous
From: "Brad Nicholson"
Date:
Subject: Re: [External] postgres 9.5 DB corruption: invalid byte sequence forencoding "UTF8"
Next
From: Tim Cross
Date:
Subject: Re: AW: Forks of pgadmin3?