Re: Triggers on foreign Postgres 9.3 tables in Postgres 9.4 - Mailing list pgsql-general

From Michael Paquier
Subject Re: Triggers on foreign Postgres 9.3 tables in Postgres 9.4
Date
Msg-id CAB7nPqQk-OYoe6k4wwm0JqBi7W=0RycN49WCE0rninyg+6r0rw@mail.gmail.com
Whole thread Raw
In response to Triggers on foreign Postgres 9.3 tables in Postgres 9.4  (MattF <mfrazier@spacetimestudios.com>)
Responses Re: Triggers on foreign Postgres 9.3 tables in Postgres 9.4  (MattF <mfrazier@spacetimestudios.com>)
List pgsql-general
On Fri, Feb 27, 2015 at 2:13 AM, MattF <mfrazier@spacetimestudios.com> wrote:
> I've talked to the admin here and he said that upgrading to Postgres 9.4 is
> possible, however the only risk is for us on the warehouse side is that it
> is entirely possible that while the warehouse servers will be Postgres 9.4,
> the production servers will remain Postgres 9.3. I haven't found a good way
> to phrase this in googling it, but will I still be able to have triggers on
> the foreign 9.3 tables from our 9.4 warehouse?

Yes, it will work. postgres_fdw speaks the Postgres protocol and uses
libpq when requesting remote servers.
--
Michael


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ANALYZE after CREATE TABLE AS SELECT...
Next
From: "Semyon Reyfman"
Date:
Subject: Re: ANALYZE after CREATE TABLE AS SELECT...