Options for Postgres FDW

From: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Options for Postgres FDW
Date: 2020-01-30 21:59:15
Message-ID: 1580421555192-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PegoraroF10 2020-01-30 22:01:08 Re: Options for Postgres FDW
Previous Message Achilleas Mantzios 2020-01-30 17:03:42 Re: Exclude constraint on ranges : commutative containment : allow only complete containment