Collected from the PG bugs email list.
|OS||Debian Linux 8|
|Reported by||Francesco Pirotti|
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 15315 Logged by: Francesco Pirotti Email address: (redacted) PostgreSQL version: 9.6.7 Operating system: Debian Linux 8 Description: I have a foreign table "t1" with two columns, "A" and "B" from mysql_fdw foreign data wrapper. I have created a trigger so that column B gets automatically a value when A is updated BEGIN NEW.B := 'dummy value'; RETURN NEW; END; if I run the following query update t1 set A='1' column B does NOT update as per trigger. if I run the following query update t1 set A='1', B='a' then column B correctly gets the 'dummy value' from the trigger function. I created an identical table in postgresql (create table t2 as select * from t1), so it is not foreign, and both updates work! Thanks for your attention: PostgreSQL 9.6.7 on x86_64-pc-linux-gnu (Debian 9.6.7-1.pgdg80+1), compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit
|2018-08-07 19:00:00+00||=?utf-8?q?PG_Bug_reporting_form?=||BUG #15315: Trigger on foreign data wrapper (MYSQL) does not update columns not in set clause|