From: | Bill MacArthur <webmaster(at)dhs-club(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | v 1.16.1 incorrectly displays the properties of a FDW table |
Date: | 2013-08-01 22:40:18 |
Message-ID: | 51FAE3D2.8050407@dhs-club.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dinesh Kumar | 2013-08-02 06:49:49 | Re: Error Messages |
Previous Message | Hall, Samuel L (Sam) | 2013-08-01 15:25:49 | Error Messages |