Error: "remote query result rowtype does not match the specified FROMclause rowtype," on remote function call
От
Antonio Gomez
Тема
Error: "remote query result rowtype does not match the specified FROMclause rowtype," on remote function call
Дата
Msg-id
BN7PR01MB365172F60FCCC2F1DBEAB873D65E0@BN7PR01MB3651.prod.exchangelabs.com
Список
Дерево обсуждения
Error: "remote query result rowtype does not match the specified FROMclause rowtype," on remote function call Antonio Gomez <AGomez@EBSCO.COM>
Re: Error: "remote query result rowtype does not match the specifiedFROM clause rowtype," on remote function call Adrian Klaver <adrian.klaver@aklaver.com>
RE: Error: "remote query result rowtype does not match the specifiedFROM clause rowtype," on remote function call Antonio Gomez <AGomez@EBSCO.COM>
Re: Error: "remote query result rowtype does not match the specifiedFROM clause rowtype," on remote function call Adrian Klaver <adrian.klaver@aklaver.com>
Re: Error: "remote query result rowtype does not match the specifiedFROM clause rowtype," on remote function call Adrian Klaver <adrian.klaver@aklaver.com>
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 по дате отправления
От: Brad Nicholson
Дата: