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
обсуждение исходный текст
Ответы Re: Error: "remote query result rowtype does not match the specifiedFROM clause rowtype," on remote function call  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: "Brad Nicholson"
Дата:
Сообщение: Re: [External] postgres 9.5 DB corruption: invalid byte sequence forencoding "UTF8"
Следующее
От: Tim Cross
Дата:
Сообщение: Re: AW: Forks of pgadmin3?