Rushabh Lathia <rushabh.lat...@gmail.com> writes: > As per the PG documentation it says that foreign table do support the > NOT NULL, NULL and DEFAULT.
There has been a great deal of debate about what constraints on foreign tables ought to mean. Right now, at least for postgres_fdw, they're just taken as documentation of constraints that are supposed to exist on the far side. It's not clear what's the point of trying to enforce them against insertions done locally if the remote table lacks them --- any table update done on the far side could still violate the constraint. We might change this in response to a well-reasoned argument, but it won't happen just because somebody lobs a quick-and-dirty patch over the fence. If we were going to enforce them locally, I'd opine it should be the FDW's task to do it, anyway. It might have more knowledge about the best way to do it than nodeModifyTable.c can, and if not it could still call ExecConstraints for itself. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers