I´m trying to insert/update some tables using FDW. I´m having problems when I want to use default values and triggers.
For columns with default values, if I drop that column on foreign table definition is fine for inserts but I cannot use that column for updates/selects because it doesn´t exist on foreign table definition. For triggers, there is a way to define search_path for that server/connection ? Because suppose I´ve used "import foreign schema CustomerSchema", when I do some insert/update on any table of this schema, if that table calls a trigger which needs another table, that trigger doesn´t sees that table because it´s using pg_catalog schema. The only way to solve this is defining search_path when starting all triggers ? -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
