On Fri, Mar 31, 2017 at 5:11 AM, Ashutosh Bapat <[email protected]> wrote: > Per https://www.postgresql.org/docs/devel/static/sql-createforeigntable.html, > constraints on the foreign table should represent a constraint that is > being enforced by the remote server.
Right. This is user error. Having the *local* server try to enforce the constraint would slow down the system without guaranteeing anything, because somebody could modify the table on the remote server directly. > Similarly, a partition constraint > should also be enforced at the foreign server. Probably we should > update documentation of create foreign table to mention this. That is a good idea. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
