Re: Triggers on foreign Postgres 9.3 tables in Postgres 9.4

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: MattF <mfrazier(at)spacetimestudios(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Triggers on foreign Postgres 9.3 tables in Postgres 9.4
Date: 2015-02-27 01:25:28
Message-ID: CAB7nPqQk-OYoe6k4wwm0JqBi7W=0RycN49WCE0rninyg+6r0rw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 27, 2015 at 2:13 AM, MattF <mfrazier(at)spacetimestudios(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Semyon Reyfman 2015-02-27 02:42:42 Re: ANALYZE after CREATE TABLE AS SELECT...
Previous Message Tom Lane 2015-02-27 01:24:52 Re: ANALYZE after CREATE TABLE AS SELECT...