Re: Options for Postgres FDW

2020-01-30 Thread Adrian Klaver
On 1/30/20 1:59 PM, PegoraroF10 wrote: 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 up

Re: Options for Postgres FDW

2020-01-30 Thread Adrian Klaver
On 1/30/20 2:01 PM, PegoraroF10 wrote: Additionally, there is a list of all options for create foreign server and create foreign table ? That is going to depend on the FDW. Options that make sense for connecting to a database make not make sense for a file based FDW. For postgres-fdw see: h

Re: Options for Postgres FDW

2020-01-30 Thread PegoraroF10
Additionally, there is a list of all options for create foreign server and create foreign table ? -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Options for Postgres FDW

2020-01-30 Thread PegoraroF10
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 o