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.