Craig Ringer <craig@2ndquadrant.com> writes:
> On 2 September 2015 at 18:46, Willy-Bas Loos <willybas@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