Hi Tom, I realize that postgres_fdw on 9.3 doesn’t support default expressions that run on the foreign server. In my case, I have a unique, auto-incrementing ID column that the remote server keeps track of in a sequence. The local foreign table doesn’t have access to this and tries to INSERT with IDs that have already been taken in the original table on the remote server. After seeing this post: http://www.postgresql.org/message-id/26654.1380145647@xxxxxxxxxxxxx, I’m hopeful honoring these default expressions in the foreign server will be supported at some point. I’m working on a project now that uses the postgres_fdw extensively. Do you know if this will be fixed in 9.4? I figure it’s worth checking since 9.4 is scheduled to be released any day now, before I start rewriting the whole project. Thanks, Tommy Duek |
