Re: [GENERAL] Triggers on foreign Postgres 9.3 tables in Postgres 9.4

2015-02-27 Thread MattF
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 mai

Re: [GENERAL] Triggers on foreign Postgres 9.3 tables in Postgres 9.4

2015-02-26 Thread Michael Paquier
On Fri, Feb 27, 2015 at 2:13 AM, MattF 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 se

[GENERAL] Triggers on foreign Postgres 9.3 tables in Postgres 9.4

2015-02-26 Thread MattF
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