pgsql: Fix contrib/postgres_fdw's handling of column defaults.

Started by Tom Laneover 13 years ago1 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

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(-)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers