Re: Bug: Foreign Data Table DDL SQL is mangled

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