v 1.16.1 incorrectly displays the properties of a FDW table

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

Responses

Browse pgadmin-support by date

  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