Tommy Duek
2014-08-21 21:15:30 UTC
Hi Tom,
I realize that postgres_fdw on 9.3 doesnt 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 doesnt 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/***@sss.pgh.pa.us, Im hopeful honoring these default expressions in the foreign server will be supported at some point.
Im working on a project now that uses the postgres_fdw extensively. Do you know if this will be fixed in 9.4? I figure its worth checking since 9.4 is scheduled to be released any day now, before I start rewriting the whole project.
Thanks,
Tommy Duek
I realize that postgres_fdw on 9.3 doesnt 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 doesnt 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/***@sss.pgh.pa.us, Im hopeful honoring these default expressions in the foreign server will be supported at some point.
Im working on a project now that uses the postgres_fdw extensively. Do you know if this will be fixed in 9.4? I figure its worth checking since 9.4 is scheduled to be released any day now, before I start rewriting the whole project.
Thanks,
Tommy Duek