Release Date: 2021-3-11

VMware Tanzu Greenplum 6.15.0 is a minor release that includes changed features and resolves several issues.

See Upgrading from an Earlier Greenplum 6 Release to upgrade your existing Greenplum 6.x software to Greenplum 6.15.

Deprecated features will be removed in a future major release of Greenplum Database. VMware Tanzu Greenplum 6.x deprecates:

• The gpsys1 utility.
• The analzyedb option --skip_root_stats (deprecated since 6.2).

  If the option is specified, a warning is issued stating that the option will be ignored.

• The server configuration parameter gp_statistics_use_fkeys (deprecated since 6.2).
• The server configuration parameter gp_ignore_error_table (deprecated since 6.0).

  To avoid a Greenplum Database syntax error, set the value of this parameter to true when you run applications that execute CREATE EXTERNAL TABLE or COPY commands that include the now removed Greenplum Database 4.3.x INTO ERROR TABLE clause.

• Specifying => as an operator name in the CREATE OPERATOR command (deprecated since 6.0).
• The Greenplum external table C API (deprecated since 6.0).

  Any developers using this API are encouraged to use the new Foreign Data Wrapper API in its place.

• Commas placed between a SUBPARTITION TEMPLATE clause and its corresponding SUBPARTITION BY clause, and between consecutive SUBPARTITION BY clauses in a CREATE TABLE command (deprecated since 6.0).

  Using this undocumented syntax will generate a deprecation warning message.

• The timestamp format YYYYMMDDHH24MISS (deprecated since 6.0).

  This format could not be parsed unambiguously in previous Greenplum Database releases, and is not supported in PostgreSQL 9.4.

• The createlang and droplang utilities (deprecated since 6.0).
• The pg_resqueue_status system view (deprecated since 6.0).

  Use the gp_toolkit.gp_resqueue_status view instead.

• The GLOBAL and LOCAL modifiers when creating a temporary table with the CREATE TABLE and CREATE TABLE AS commands (deprecated since 6.0).

  These keywords are present for SQL standard compatibility, but have no effect in Greenplum Database.

• Using WITH OIDS or oids=TRUE to assign an OID system column when creating or altering a table (deprecated since 6.0).
• Allowing superusers to specify the SQL_ASCII encoding regardless of the locale settings (deprecated since 6.0).

  This choice may result in misbehavior of character-string functions when data that is not encoding-compatible with the locale is stored in the database.

• The @@@ text search operator (deprecated since 6.0).

  This operator is currently a synonym for the @@ operator.

• The unparenthesized syntax for option lists in the VACUUM command (deprecated since 6.0).

  This syntax requires that the options to the command be specified in a specific order.

• The plain pgbouncer authentication type (auth_type = plain) (deprecated since 4.x).

Greenplum 6 supports direct upgrades, using gpupgrade, from Greenplum 5.x releases to Greenplum 6.x. For more information, see the gpupgrade documentation. See also Migrating Data from Greenplum 4.3 or 5 for guidelines and considerations for migrating existing Greenplum data to Greenplum 6, using standard backup and restore procedures.

VMware Tanzu Greenplum 6 has these limitations:

• Upgrading a Greenplum Database 4 release to VMware Tanzu Greenplum 6 is not supported. Upgrading a Greenplum Database 5.x release to VMware Tanzu Greenplum 6 is supported via gpupgrade. For more information, see the gpupgrade documentation.
• MADlib, GPText, and PostGIS are not yet provided for installation on Ubuntu systems.
• Greenplum for Kubernetes is not yet provided with this release.

The following table lists key known issues in VMware Tanzu Greenplum 6.x.

SELECT inhrelid::regclass FROM pg_inherits,
  gp_distribution_policy dp
WHERE inhrelid=dp.localoid AND dp.policytype='r';
SELECT inhparent::regclass FROM pg_inherits,
  gp_distribution_policy dp
WHERE inhparent=dp.localoid AND dp.policytype='r';

createlang: language installation failed: ERROR:
no schema has been selected to create in