- Pivotal Greenplum Database (GPDB) 4.3.x
- Operating System- All supported
When creating a table with an array, the command would fail and generate the following error:
testDB=# CREATE TYPE mytype as (name text, price int);
testDB=# create table test1 (col1 mytype);
NOTICE: Table doesn't have 'distributed by' clause, and no column type is suitable for a distribution key. Creating a NULL policy entry.
testDB=# create table test2 (col1 mytype);
ERROR: type "mytype" does not exist
GPDB 4.3.x does not support array for composite type.
Greenplum(GPDB) 5.x.x will support this feature. Please update as soon as it is available if table array is a tool you need to use frequently.