Craig Ringer <craig@xxxxxxxxxxxxxxx> writes: > On 2 September 2015 at 18:46, Willy-Bas Loos <willybas@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
