The DDL in the Table Browser of GPCC is missing appendonly and orientation parameters

Products

• VMware Tanzu Data Suite
• VMware Tanzu Data Suite
• Greenplum
• VMware Tanzu Greenplum

Issue/Introduction

When viewing the DDL of tables in the Table Browser of Greenplum Command Center(GPCC) some of the options may be missing.

For AppendOptimised(AO) or AppendOptimised ColumnOrientated(AOCO) tables, the DDL is missing the "appendonly" and "orientation" parameters. This issue is only present in GPCC 7.x.

Also if the tables are created in user defined tablespaces, the "tablespace" parameter is missing. This issue is present in GPCC 6.x and 7.x.

Cause

GPCC depends on the DDL provide by pg_dump. GPCC just shows the CREATE statement from the pg_dump in the DDL.

However pg_dump can set GUCs in the backup dump which are ignored by GPCC. The GUCs such as:

• "default_table_access_method" which specifies the AO and AOCO parameters in Greenplum 7.x
• "default_tablespace" which specifies the tablespace used by the table is missing in Greenplum 6.x and 7.x

 

Resolution

As of January 2025, R&D are working on a fix for the issue. A fix will be released in future maintenance releases

Search the GPCC Release Notes for issue "33731" to check if the fix has been released.