Andres Freund wrote:
> On 2015-09-02 20:27:40 +0800, Craig Ringer wrote:
> > 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.
>
> As Tom explained thats not the case for either of those two. To my
> knowledge the only reason those two commands aren't implemented is that
> either nobody implemented the required ddl deparsing or, actually
> somewhat likely, nobody removed the error check. Either way it should be
> simple to implement.
Deparsing for FDW objects is in the patch that got committed for 9.5
(actually, Andres himself implemented those bits), but I'm not sure that
it was in the version used by the 9.4-BDR branch. Anyway, even if it's
not there, it should be reasonably simple to lift the code from 9.5 into
BDR's branch. And then remove the restrictions.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
