Re: v 1.16.1 incorrectly displays the properties of a FDW table - Mailing list pgadmin-support
Hi Dave,
We are able to re-produce the same case in windows xp, but not in windows 7. Below is the output for the table which has been created in PG 9.2.
XP (pgAdmin 1.16.1)
-----
-----
CREATE FOREIGN TABLE person
(name text ,
spouse text )
SERVER file_fdw_serv
OPTIONS (format 'text,filename=/tmp/test.txt,', elimiter '', , '', ull '\\\\N"');
ALTER FOREIGN TABLE person
OWNER TO postgres;
Win 7 (pgAdmin 1.16.1)
--------
CREATE FOREIGN TABLE person
(name text ,
spouse text )
SERVER file_fdw_serv
OPTIONS (format 'text', filename '/tmp/test.txt', delimiter ',', null 'N');
ALTER FOREIGN TABLE person
OWNER TO postgres;
--------
CREATE FOREIGN TABLE person
(name text ,
spouse text )
SERVER file_fdw_serv
OPTIONS (format 'text', filename '/tmp/test.txt', delimiter ',', null 'N');
ALTER FOREIGN TABLE person
OWNER TO postgres;
Actual Definitions From PG (9.2)
------------------------------------
postgres=# \d person
Foreign table "public.person"
Column | Type | Modifiers | FDW Options
--------+------+-----------+-------------
name | text | |
spouse | text | |
Server: file_fdw_serv
FDW Options: (format 'text', filename '/tmp/test.txt', delimiter ',', "null" E'\\\\N')
------------------------------------
postgres=# \d person
Foreign table "public.person"
Column | Type | Modifiers | FDW Options
--------+------+-----------+-------------
name | text | |
spouse | text | |
Server: file_fdw_serv
FDW Options: (format 'text', filename '/tmp/test.txt', delimiter ',', "null" E'\\\\N')
I believe, the code in "pgForeignTable::iSetOptions(const wxString &tmpoptions)" is behaving differently on windows xp as well in 7.
I have installed the PG 9.3 beta version which comes with pgAdmin 1.18.x in Win XP. In that version also, win xp is behaving like reported. Hence, i would like to setup the build in XP and will try to fix the problem.
Kindly let me know your inputs.
Thanks in advance.
Dinesh
--
Dinesh Kumar
.jpg)
Ph: +918087463317
Follow us on Twitter
@EnterpriseDB
Visit EnterpriseDB for tutorials, webinars, whitepapers and more
--
Dinesh Kumar
Software Engineer
Ph: +918087463317
Skype ID: dinesh.kumar432
www.enterprisedb.comFollow us on Twitter
@EnterpriseDB
Visit EnterpriseDB for tutorials, webinars, whitepapers and more
On Mon, Aug 5, 2013 at 11:49 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Sure Dave, will work on this issue.Dinesh
--
Dinesh KumarSoftware EngineerSkype ID: dinesh.kumar432www.enterprisedb.com
Follow us on Twitter
@EnterpriseDB
Visit EnterpriseDB for tutorials, webinars, whitepapers and moreOn Fri, Aug 2, 2013 at 11:00 PM, Dave Page <dpage@pgadmin.org> wrote:Dinesh, can you look at this please? Thanks.--
On Thu, Aug 1, 2013 at 11:40 PM, Bill MacArthur <webmaster@dhs-club.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@postgresql.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
pgadmin-support by date: