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

[Antonio Gomez <AGomez@xxxxxxxxx>]

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!