| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
| Cc: | Willy-Bas Loos <willybas(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: FDW and BDR |
| Date: | 2015-09-02 12:34:07 |
| Message-ID: | 23691.1441197247@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Craig Ringer <craig(at)2ndquadrant(dot)com> writes:
> On 2 September 2015 at 18:46, Willy-Bas Loos <willybas(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Willy-Bas Loos | 2015-09-02 12:40:10 | Re: Re: (expert) "insert into VIEW returning" inside an instead of trigger returns nothing |
| Previous Message | Craig Ringer | 2015-09-02 12:27:40 | Re: FDW and BDR |