[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 ?
Re: [HACKERS] If subscription to foreign table valid ? Re: [HACKERS] If subscription to foreign table valid ? |
| Список | 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 по дате отправления: