Thread: pgsql: Fix contrib/postgres_fdw's handling of column defaults.
Fix contrib/postgres_fdw's handling of column defaults. Adopt the position that only locally-defined defaults matter. Any defaults defined in the remote database do not affect insertions performed through a foreign table (unless they are for columns not known to the foreign table). While it'd arguably be more useful to permit remote defaults to be used, making that work in a consistent fashion requires far more work than seems possible for 9.3. Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/50c19fc76f05124b80fc4c5d20a359c5dbf017af Modified Files -------------- contrib/postgres_fdw/deparse.c | 55 ++--- contrib/postgres_fdw/expected/postgres_fdw.out | 285 ++++++++++++------------ contrib/postgres_fdw/postgres_fdw.c | 43 +++- contrib/postgres_fdw/postgres_fdw.h | 9 +- contrib/postgres_fdw/sql/postgres_fdw.sql | 15 +- 5 files changed, 205 insertions(+), 202 deletions(-)