postgres_fdw foreign tables and serial columns

Поиск
Список
Период
Сортировка
От Nicholson, Brad (Toronto, ON, CA)
Тема postgres_fdw foreign tables and serial columns
Дата
Msg-id EC55DC235432104F8255702A8D7344D9418B5F0D@G4W3302.americas.hpqcorp.net
обсуждение исходный текст
Ответы Re: postgres_fdw foreign tables and serial columns
Список pgsql-hackers
Hi,

I'm kicking the tires on the 9.3 postgres_fdw stuff - I'm not sure if this is an issue or intended behavior, but it was
prettyconfusing based on the error message that was output.  If you try creating a foreign table with a reference to a
serialdata type, it comes back with a "referenced relation is not a table" error.  If you change the data type in the
referencedtable to integer - then it works.  Completely understand why this is needed - but it tripped me up for a
while. At the very least, can I suggest adding something in the documentation about serial columns (if it is not an
issue)? 
test=# create table foo (id serial);
CREATE TABLE

test=# create foreign table local_foo (id serial) server test_server options (table_name 'foo');
                                   
ERROR:  referenced relation "local_foo" is not a table

test=# create foreign table local_foo (id integer) server test_server options (table_name 'foo');
CREATE FOREIGN TABLE

Brad



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Proposed TODO: add support for "any" for PL/PythonU and PL/Perl
Следующее
От: Amit Langote
Дата:
Сообщение: Re: Logging of PAM Authentication Failure