From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Paragon Corporation <lr(at)pcorp(dot)us> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Bug: Foreign Data Table DDL SQL is mangled |
Date: | 2012-04-17 21:39:37 |
Message-ID: | 1334698777.2325.37.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Mon, 2012-04-16 at 23:59 +0200, Guillaume Lelarge wrote:
> 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.
>
Fixed.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-04-17 21:40:33 | Re: Bug: Foreign Data Table DDL SQL is mangled |
Previous Message | Luiz Eduardo | 2012-04-17 20:23:36 | show application_name |