[HACKERS] If subscription to foreign table valid ?

Поиск
Список
Период
Сортировка
От tushar
Тема [HACKERS] If subscription to foreign table valid ?
Дата
Msg-id 6bac159c-4ba0-c33f-d01f-33ba01a36105@enterprisedb.com
обсуждение исходный текст
Ответы Re: [HACKERS] If subscription to foreign table valid ?  (Robert Haas <robertmhaas@gmail.com>)
Re: [HACKERS] If subscription to foreign table valid ?  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Re: [HACKERS] If subscription to foreign table valid ?  (Noah Misch <noah@leadboat.com>)
Список pgsql-hackers
Hi,

I observed that -we cannot publish "foreign table" in Publication

postgres=# create foreign table t (n int) server db1_server options 
(table_name 't1');
CREATE FOREIGN TABLE

postgres=# create publication pub for table t;
ERROR:  "t" is not a table
DETAIL:  Only tables can be added to publications.
postgres=#

but same thing is not true for Subscription

postgres=# create foreign table t (n int) server db1_server options 
(table_name 't');
CREATE FOREIGN TABLE
postgres=# alter subscription sub refresh publication ;
NOTICE:  added subscription for table public.t
ALTER SUBSCRIPTION

Is this an expected behavior ?   if we cannot publish then how  can we  
add subscription for it.

-- 
regards,tushar
EnterpriseDB  https://www.enterprisedb.com/
The Enterprise PostgreSQL Company




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

Предыдущее
От: Amit Khandekar
Дата:
Сообщение: Re: [HACKERS] UPDATE of partition key
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] alter table..drop constraint pkey, left not null un-dropped