On Mon, 2012-04-16 at 09:12 -0400, Paragon Corporation wrote: > I'm testing on Windows 2008 64-bit pgAdmin 1.14.2 > > I used the odbc_fdw based foreign data table that I created with this > statement: > > CREATE FOREIGN TABLE my_tables > (table_catalog character varying(128) , > table_schema character varying(128) , > table_name character varying(128) , > table_type character varying(128) ) > SERVER localsql2005 > OPTIONS (database 'myserver2005', sql_query 'SELECT CAST(TABLE_CATALOG As > varchar(128)) As table_catalog > , CAST(TABLE_SCHEMA As varchar(128)) As table_schema, CAST(TABLE_NAME As > varchar(128)) As table_name > , CAST(TABLE_TYPE As varchar(128)) As table_type > FROM information_schema.tables', sql_count 'select count(TABLE_NAME) from > information_schema.tables'); > > > When I use pgAdmin to regenerate the SQL ddl for it, it generates this > malformed thing that can't be run: > > > CREATE FOREIGN TABLE my_tables > (table_catalog character varying(128) , > table_schema character varying(128) , > table_name character varying(128) , > table_type character varying(128) ) > SERVER localsql2005 > OPTIONS (database 'myserver2005', sql_query 'SELECT CAST(TABLE_CATALOG As > varchar(128)) As table_catalog > , CAST(TABLE_SCHEMA As varchar(128)) As table_schema, CAST(TABLE_NAME As > varchar(128)) As table_name > , CAST(TABLE_TYPE As varchar(128)) As table_type > FROM information_schema.tables', ,"sql_count 'select count(TABLE_NAME) from > information_schema.tables"'); >
I reproduce your issue. I'll work on that tomorrow evening. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
