Re: [HACKERS] alter server for foreign table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] alter server for foreign table
Дата
Msg-id 21718.1506805727@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] alter server for foreign table  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Список pgsql-hackers
Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes:
> I assume the proposal is to allow changing to a different server using
> the same FDW. I can see all sorts of odd things happening if we allow
> changing to a server of a different FDW.

As long as we check that the table's FDW options are acceptable to the
new FDW, where's the problem?  I could see there being an issue if we
provided any hook whereby FDW could have a say during CREATE FOREIGN
TABLE (or DROP FOREIGN TABLE), but we don't.  So as far as the FDWs
are concerned, this should be little different from dropping the foreign
table and then remaking it attached to the new server.
        regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: [HACKERS] Causal reads take II
Следующее
От: Pavel Stehule
Дата:
Сообщение: [HACKERS] why subplan is 10x faster then function?