Re: v 1.16.1 incorrectly displays the properties of a FDW table

Sure Dave, will work on this issue.

Dinesh

--
*Dinesh Kumar*
Software Engineer

Ph: +918087463317
Skype ID: dinesh.kumar432
www.enterprisedb.co
<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
*
Follow us on Twitter*
@EnterpriseDB

Visit EnterpriseDB for tutorials, webinars,
whitepapers<http://www.enterprisedb.com/resources-community> and
more <http://www.enterprisedb.com/resources-community>

On Fri, Aug 2, 2013 at 11:00 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Dinesh, can you look at this please? Thanks.
>
> On Thu, Aug 1, 2013 at 11:40 PM, Bill MacArthur <webmaster(at)dhs-club(dot)com>
> wrote:
> > Hello,
> >
> > I am guessing that somebody has already reported this, but in case not,
> here
> > goes. I am using version 1.16.1 on windows XP against a Postgres version
> > 9.2.4 server. The wrapper options for a foreign data wrappers table get
> > really goobered up inside of pgadmin.
> > I have a foreign table that is defined by \d as:
> >
> > network=# \d test.grpmgt
> > Foreign table "test.grpmgt"
> > Column | Type | Modifiers | FDW Options
> > --------+---------+-----------+-------------
> > id | integer | |
> > uptime | integer | |
> > paid | boolean | |
> > Server: file_server
> > FDW Options: (format 'text', filename '/tmp/grpmgt', delimiter ',',
> "null"
> > E'\\\\N')
> >
> >
> > However, the same object is reported in pgadmin as:
> >
> > CREATE FOREIGN TABLE work.grpmgt
> > (id integer ,
> > upline integer ,
> > paid boolean )
> > SERVER file_server
> > OPTIONS (format 'text,filename=/tmp/grpmgt,', elimiter '', , '', ull
> > '\\\\N"');
> >
> >
> > As you can well imagine, that SQL statement cannot recreate that table.
> It
> > breaks down in the OPTIONS.
> >
> > Pgadmin is a wonderful tool and this aberration is of minimal
> consequence to
> > me, but I figure that the least I could do to help make it better would
> be
> > to report this.
> >
> > Thank you much.
> > Bill MacArthur
> >
> >
> > --
> > Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgadmin-support
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>