Triggers on foreign Postgres 9.3 tables in Postgres 9.4

Started by MattFabout 11 years ago3 messagesgeneral
Jump to latest
#1MattF
mfrazier@spacetimestudios.com

My company has a data warehouse, currently running on Postgres 9.3, as well
as the production servers also running on Postgres 9.3. We have connections
to foreign tables from the warehouse, however I've noticed that implementing
triggers on foreign tables is not supported in Postgres 9.3, and is a new
feature in Postgres 9.4.

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?

If this question makes no sense, please let me know and I will try to reword
it.

--
View this message in context: http://postgresql.nabble.com/Triggers-on-foreign-Postgres-9-3-tables-in-Postgres-9-4-tp5839559.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Michael Paquier
michael@paquier.xyz
In reply to: MattF (#1)
Re: Triggers on foreign Postgres 9.3 tables in Postgres 9.4

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#3MattF
mfrazier@spacetimestudios.com
In reply to: Michael Paquier (#2)
Re: Triggers on foreign Postgres 9.3 tables in Postgres 9.4

Thank you Michael! I will let the admin know then!

--
View this message in context: http://postgresql.nabble.com/Triggers-on-foreign-Postgres-9-3-tables-in-Postgres-9-4-tp5839559p5839749.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general