[teiid-issues] [JBoss JIRA] (TEIID-4251) Built in support for Postgres DB as materialization target

[ https://issues.jboss.org/browse/TEIID-4251?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-4251 at 10/4/18 11:04 AM: ----------------------------------------------------------------- Issues with this approach: - fail fast? the fdw seems to hang if the remote server is not available, but that shouldn't really be a concern - expanded transaction statement support. the fdw expects more syntax for start transaction and abort transaction - import seems to succeed and the tables are visible in pg_class, but they are not resolvable -- using create foreign table... does create a querable table - but of course is not what I was going for - the execution against a foreign table uses a prepared cursor syntax than we currently have support for was (Author: shawkins): Issues with this approach: - fail fast? the fdw seems to hang if the remote server is not available, but that shouldn't really be a concern - expanded transaction statement support. the fdw expects more syntax for start transaction and abort transaction - import seems to succeed and the tables are visible in pg_class, but they are not resolvable -- using create foreign table... does create a querable table - but of course is not what I was going for - the execution against a foreign table uses a different declare cursor syntax than we currently have support for -- This message was sent by Atlassian Jira (v7.12.1#712002)