Re: BUG #9478: Greenplum External Table definitions

I posted the bug on pgadmin site
Michael Gerstein | Architect=20

Pivotal | www.GoPivotal.com

m: +1.732.768.9891 | e: mgerstein@gopivotal.com


On Mar 18, 2014, at 9:14 PM, Bruce Momjian <bruce@momjian.us> wrote:

> On Tue, Mar 18, 2014 at 09:05:12PM -0400, Michael Gerstein wrote:
>> It is not  a Greenplum bug, because the query is working fine in =
Greenplum and
>> returns proper values. Besides, the version 1.10.5 works correctly.
>> This functionality was broken after the version of 1.10.5 in pgAdmin
>=20
> Well, I am not sure how I was supposed to guess that pgadmin was
> involved here.   I suggest you report it to them then.
>=20
> =
--------------------------------------------------------------------------=
-
>=20
>=20
>>=20
>> Michael Gerstein | Architect=20
>>=20
>> Pivotal | www.GoPivotal.com
>>=20
>> m: +1.732.768.9891 | e: mgerstein@gopivotal.com
>>=20
>>=20
>> On Mar 18, 2014, at 9:00 PM, Bruce Momjian <bruce@momjian.us> wrote:
>>=20
>>=20
>>    On Fri, Mar  7, 2014 at 09:07:10PM +0000, mgerstein@gopivotal.com =
wrote:
>>=20
>>        The following bug has been logged on the website:
>>=20
>>        Bug reference:      9478
>>        Logged by:          Michael Gerstein
>>        Email address:      mgerstein@gopivotal.com
>>        PostgreSQL version: Unsupported/Unknown
>>        Operating system:   Linux
>>        Description:       =20
>>=20
>>        "PostgreSQL 8.2.15 (Greenplum Database 4.3.0.0 build 3) on
>>        x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 =
compiled on
>>        Nov 23
>>        2013 01:22:06"
>>=20
>>        After the version 1.10.5 external table definition is broken =
for
>>        Greenplum
>>        database.
>>        While the query properly returns the datatypes for the columns =
(checked
>>        in
>>        Greenplum), the types are not shown in the table definition. =
Since Ext.
>>        table definition is in separate file in the souce, I guess, =
there is
>>        the bug
>>        somewhere there, which omits column types.
>>=20
>>=20
>>    This is a Greenplum bug, rather than a Postgres one.  I suggest =
you
>>    contact Greenplum.
>>=20
>>    --
>>     Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>>     EnterpriseDB                             http://enterprisedb.com
>>=20
>>     + Everyone has their own god. +
>>=20
>>=20
>=20
> --=20
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>=20
>  + Everyone has their own god. +