Craig Ringer <cr...@2ndquadrant.com> writes:
> On 2 September 2015 at 18:46, Willy-Bas Loos <willy...@gmail.com> wrote:
>> I've read that CREATE FOREIGN DATA WRAPPER currently is prohibited on BDR
>> enabled databases. And other FDW and FTS related commands too.
> Correct.
> The reason for this is that BDR replicates at a database level, but
> CREATE SERVER and CREATE USER MAPPING are global, affecting all
> databases on a PostgreSQL install. BDR can't therefore guarantee to
> replicate CREATE SERVER to other nodes, since it might get run on a
> non-BDR-enabled database.
Uh ... what?
I do not know what the actual reason for this restriction is, but that
explanation is nonsense. There are no shared catalogs involved with
FDWs.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
