Re: BUG #9478: Greenplum External Table definitions - Mailing list pgsql-bugs

On Fri, Mar  7, 2014 at 09:07:10PM +0000, mgerstein@gopivotal.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      9478
> Logged by:          Michael Gerstein
> Email address:      mgerstein@gopivotal.com
> PostgreSQL version: Unsupported/Unknown
> Operating system:   Linux
> Description:
>
> "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"
>
> 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.

This is a Greenplum bug, rather than a Postgres one.  I suggest you
contact Greenplum.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +