Features and Objects Removed in WarehousePG 7

WarehousePG 7 removes several database features and objects. These changes can potentially affect successfully upgrading from one major version to another. Review this list of removed features and objects before upgrading from WarehousePG 6 to WarehousePG 7.

Removed Features

The following features have been removed in WarehousePG 7:

Support for Quicklz compression. To avoid breaking applications that use Quicklz, set the gp_quicklz_fallback server configuration parameter to true.
The --skip_root_stats option of the analyzedb utility. analyzedb populates root statistics required by the optimizer by default.
The WarehousePG R Client.
WarehousePG MapReduce.
The ARRAY_NAME variable. It is no longer used by WarehousePG.
The PL/Container 3.0 Beta extension. Instead, use the regular PL/Container extension.
The gp_percentil_agg extension. This is not part of the core WarehousePG product.
The createlang and droplang utilties. Instead, use CREATE EXTENSION and DROP EXTENSION directly.
Support for python2 and the plpythonu extension.

Removed Objects

This section summarizes objects removed in WarehousePG 7.

Removed Tables and Views
Removed Columns
Removed Functions and Procedures
Removed Types, Domains, and Composite Types
Removed Operators

Removed Tables and Views

The following list includes the tables and views removed in WarehousePG 7.

gp_toolkit.gp_size_of_partition_and_indexes_disk
gp_toolkit.__gp_user_data_tables
pg_catalog.pg_partition
pg_catalog.pg_partition_columns
pg_catalog.pg_partition_encoding
pg_catalog.pg_partition_rule
pg_catalog.pg_partitions
pg_catalog.pg_partition_templates
pg_catalog.pg_stat_partition_operations

Removed Columns

The following list includes the columns removed in WarehousePG 7.

gp_toolkit.gp_locks_on_resqueue.lorwaiting
gp_toolkit.gp_resgroup_config.cpu_rate_limit
gp_toolkit.gp_resgroup_config.memory_auditor
gp_toolkit.gp_resgroup_config.memory_shared_quota
gp_toolkit.gp_resgroup_config.memory_spill_ratio
gp_toolkit.gp_resgroup_status.cpu_usage
gp_toolkit.gp_resgroup_status.memory_usage
gp_toolkit.gp_resgroup_status_per_host.cpu
gp_toolkit.gp_resgroup_status_per_host.memory_available
gp_toolkit.gp_resgroup_status_per_host.memory_quota_available
gp_toolkit.gp_resgroup_status_per_host.memory_quota_used
gp_toolkit.gp_resgroup_status_per_host.memory_shared_available
gp_toolkit.gp_resgroup_status_per_host.memory_shared_used
gp_toolkit.gp_resgroup_status_per_host.memory_used
gp_toolkit.gp_resgroup_status_per_host.rsgname
gp_toolkit.gp_resgroup_status_per_segment.cpu
gp_toolkit.gp_resgroup_status_per_segment.hostname
gp_toolkit.gp_resgroup_status_per_segment.memory_available
gp_toolkit.gp_resgroup_status_per_segment.memory_quota_available
gp_toolkit.gp_resgroup_status_per_segment.memory_quota_used
gp_toolkit.gp_resgroup_status_per_segment.memory_shared_available
gp_toolkit.gp_resgroup_status_per_segment.memory_shared_used
gp_toolkit.gp_resgroup_status_per_segment.memory_used
gp_toolkit.gp_resgroup_status_per_segment.rsgname
gp_toolkit.gp_resgroup_status.rsgname
gp_toolkit.__gp_user_tables.autrelstorage
information_schema.routines.result_cast_character_set_name
information_schema.routines.sql_data_access
pg_catalog.gp_configuration_history.desc
pg_catalog.gp_distributed_log.distributed_id
pg_catalog.gp_distributed_xacts.distributed_id
pg_catalog.gp_stat_replication.flush_location
pg_catalog.gp_stat_replication.replay_location
pg_catalog.gp_stat_replication.sent_location
pg_catalog.gp_stat_replication.write_location
pg_catalog.pg_proc.protransform
pg_catalog.pg_proc.proisagg
pg_catalog.pg_proc.proiswindow
pg_catalog.pg_am.ambeginscan
pg_catalog.pg_am.ambuild
pg_catalog.pg_am.ambuildempty
pg_catalog.pg_am.ambulkdelete
pg_catalog.pg_am.amcanbackward
pg_catalog.pg_am.amcanmulticol
pg_catalog.pg_am.amcanorder
pg_catalog.pg_am.amcanorderbyop
pg_catalog.pg_am.amcanreturn
pg_catalog.pg_am.amcanunique
pg_catalog.pg_am.amclusterable
pg_catalog.pg_am.amcostestimate
pg_catalog.pg_am.amendscan
pg_catalog.pg_am.amgetbitmap
pg_catalog.pg_am.amgettuple
pg_catalog.pg_am.aminsert
pg_catalog.pg_am.amkeytype
pg_catalog.pg_am.ammarkpos
pg_catalog.pg_am.amoptionalkey
pg_catalog.pg_am.amoptions
pg_catalog.pg_am.ampredlocks
pg_catalog.pg_am.amrescan
pg_catalog.pg_am.amrestrpos
pg_catalog.pg_am.amsearcharray
pg_catalog.pg_am.amsearchnulls
pg_catalog.pg_am.amstorage
pg_catalog.pg_am.amstrategies
pg_catalog.pg_am.amsupport
pg_catalog.pg_am.amvacuumcleanup
pg_catalog.pg_appendonly.blkdiridxid
pg_catalog.pg_appendonly.blocksize
pg_catalog.pg_appendonly.checksum
pg_catalog.pg_appendonly.columnstore
pg_catalog.pg_appendonly.compresslevel
pg_catalog.pg_appendonly.compresstype
pg_catalog.pg_appendonly.safefswritesize
pg_catalog.pg_appendonly.visimapidxid
pg_catalog.pg_attrdef.adsrc
pg_catalog.pg_authid.rolcatupdate
pg_catalog.pg_class.relhasoids
pg_catalog.pg_class.relhaspkey
pg_catalog.pg_class.relstorage
pg_catalog.pg_constraint.consrc

Removed Functions

The following list includes the functions removed in WarehousePG 7.

pg_catalog.abstime
pg_catalog.abstimeeq
pg_catalog.abstimege
pg_catalog.abstimegt
pg_catalog.abstimein
pg_catalog.abstimele
pg_catalog.abstimelt
pg_catalog.abstimene
pg_catalog.abstimeout
pg_catalog.abstimerecv
pg_catalog.abstimesend
pg_catalog.bmbeginscan
pg_catalog.bmbuild
pg_catalog.bmbuildempty
pg_catalog.bmbulkdelete
pg_catalog.bmcostestimate
pg_catalog.bmendscan
pg_catalog.bmgetbitmap
pg_catalog.bmgettuple
pg_catalog.bminsert
pg_catalog.bmmarkpos
pg_catalog.bmoptions
pg_catalog.bmrescan
pg_catalog.bmrestrpos
pg_catalog.bmvacuumcleanup
pg_catalog.btabstimecmp
pg_catalog.btbeginscan
pg_catalog.btbuild
pg_catalog.btbuildempty
pg_catalog.btbulkdelete
pg_catalog.btcanreturn
pg_catalog.btcostestimate
pg_catalog.btendscan
pg_catalog.btgetbitmap
pg_catalog.btgettuple
pg_catalog.btinsert
pg_catalog.btmarkpos
pg_catalog.btoptions
pg_catalog.btreltimecmp
pg_catalog.btrescan
pg_catalog.btrestrpos
pg_catalog.bttintervalcmp
pg_catalog.btvacuumcleanup
pg_catalog.cdblegacyhash_abstime
pg_catalog.cdblegacyhash_reltime
pg_catalog.cdblegacyhash_tinterval
pg_catalog.ginbeginscan
pg_catalog.ginbuild
pg_catalog.ginbuildempty
pg_catalog.ginbulkdelete
pg_catalog.gincostestimate
pg_catalog.ginendscan
pg_catalog.gingetbitmap
pg_catalog.gininsert
pg_catalog.ginmarkpos
pg_catalog.ginoptions
pg_catalog.ginrescan
pg_catalog.ginrestrpos
pg_catalog.ginvacuumcleanup
pg_catalog.gistbeginscan
pg_catalog.gist_box_compress
pg_catalog.gist_box_decompress
pg_catalog.gistbuild
pg_catalog.gistbuildempty
pg_catalog.gistbulkdelete
pg_catalog.gistcostestimate
pg_catalog.gistendscan
pg_catalog.gistgetbitmap
pg_catalog.gistgettuple
pg_catalog.gistinsert
pg_catalog.gistmarkpos
pg_catalog.gistoptions
pg_catalog.gistrescan
pg_catalog.gistrestrpos
pg_catalog.gistvacuumcleanup
pg_catalog.gp_elog
pg_catalog.gp_fault_inject
pg_catalog.gp_quicklz_compress
pg_catalog.gp_quicklz_constructor
pg_catalog.gp_quicklz_decompress
pg_catalog.gp_quicklz_destructor
pg_catalog.gp_quicklz_validator
pg_catalog.gp_update_ao_master_stats
pg_catalog.gtsquery_decompress
pg_catalog.hashbeginscan
pg_catalog.hashbuild
pg_catalog.hashbuildempty
pg_catalog.hashbulkdelete
pg_catalog.hashcostestimate
pg_catalog.hashendscan
pg_catalog.hashgetbitmap
pg_catalog.hashgettuple
pg_catalog.hashinsert
pg_catalog.hashint2vector
pg_catalog.hashmarkpos
pg_catalog.hashoptions
pg_catalog.hashrescan
pg_catalog.hashrestrpos
pg_catalog.hashvacuumcleanup
pg_catalog.inet_gist_decompress
pg_catalog.int2vectoreq
pg_catalog.interval
pg_catalog.interval_transform
pg_catalog.mktinterval
pg_catalog.numeric2point
pg_catalog.numeric_transform
pg_catalog.pg_current_xlog_insert_location
pg_catalog.pg_current_xlog_location
pg_catalog.pg_get_partition_def
pg_catalog.pg_get_partition_rule_def
pg_catalog.pg_get_partition_template_def
pg_catalog.pg_is_xlog_replay_paused
pg_catalog.pg_last_xlog_receive_location
pg_catalog.pg_last_xlog_replay_location
pg_catalog.pg_stat_get_backend_waiting
pg_catalog.pg_stat_get_backend_waiting_reason
pg_catalog.pg_switch_xlog
pg_catalog.pg_xlogfile_name
pg_catalog.pg_xlogfile_name_offset
pg_catalog.pg_xlog_location_diff
pg_catalog.pg_xlog_replay_pause
pg_catalog.pg_xlog_replay_resume
pg_catalog.range_gist_compress
pg_catalog.range_gist_decompress
pg_catalog.reltime
pg_catalog.reltimeeq
pg_catalog.reltimege
pg_catalog.reltimegt
pg_catalog.reltimein
pg_catalog.reltimele
pg_catalog.reltimelt
pg_catalog.reltimene
pg_catalog.reltimeout
pg_catalog.reltimerecv
pg_catalog.reltimesend
pg_catalog.smgreq
pg_catalog.smgrin
pg_catalog.smgrne
pg_catalog.smgrout
pg_catalog.spgbeginscan
pg_catalog.spgbuild
pg_catalog.spgbuildempty
pg_catalog.spgbulkdelete
pg_catalog.spgcanreturn
pg_catalog.spgcostestimate
pg_catalog.spgendscan
pg_catalog.spggetbitmap
pg_catalog.spggettuple
pg_catalog.spginsert
pg_catalog.spgmarkpos
pg_catalog.spgoptions
pg_catalog.spgrescan
pg_catalog.spgrestrpos
pg_catalog.spgvacuumcleanup
pg_catalog.timemi
pg_catalog.timenow
pg_catalog.timepl
pg_catalog.timestamp_transform
pg_catalog.time_transform
pg_catalog.tinterval
pg_catalog.tintervalct
pg_catalog.tintervalend
pg_catalog.tintervaleq
pg_catalog.tintervalge
pg_catalog.tintervalgt
pg_catalog.tintervalin
pg_catalog.tintervalle
pg_catalog.tintervalleneq
pg_catalog.tintervallenge
pg_catalog.tintervallengt
pg_catalog.tintervallenle
pg_catalog.tintervallenlt
pg_catalog.tintervallenne
pg_catalog.tintervallt
pg_catalog.tintervalne
pg_catalog.tintervalout
pg_catalog.tintervalov
pg_catalog.tintervalrecv
pg_catalog.tintervalrel
pg_catalog.tintervalsame
pg_catalog.tintervalsend
pg_catalog.tintervalstart
pg_catalog.varbit_transform
pg_catalog.varchar_transform

Removed Types and Composite Types

The following list includes the types and composite types removed in WarehousePG 7.

Types

pg_catalog._reltime
pg_catalog.reltime
pg_catalog.smgr
pg_catalog._tinterval
pg_catalog.tinterval
pg_catalog._abstime
pg_catalog.abstim

Composite Types

gp_toolkit.gp_size_of_partition_and_indexes_disk
gp_toolkit.__gp_user_data_tables
pg_catalog.pg_partition
pg_catalog.pg_partition_columns
pg_catalog.pg_partition_encoding
pg_catalog.pg_partition_rule
pg_catalog.pg_partitions
pg_catalog.pg_partition_templates
pg_catalog.pg_stat_partition_operations

Removed Operators

The following list includes the operators removed in WarehousePG 7.

oprname	oprcode
pg_catalog.=	abstimeeq
pg_catalog.>=	abstimege
pg_catalog.>	abstimegt
pg_catalog.<=	abstimele
pg_catalog.<	abstimelt
pg_catalog.<>
pg_catalog.=	int2vectoreq
pg_catalog.<?>	intinterval
pg_catalog.<#>	mktinterval
pg_catalog.=	reltimeeq
pg_catalog.>	reltimege
pg_catalog.>	reltimegt
pg_catalog.<=	reltimele
pg_catalog.<	reltimelt
pg_catalog.<>	reltimene
pg_catalog.-	timemi
pg_catalog.+	timepl
pg_catalog.<<	tintervalct
pg_catalog.=	tintervaleq
pg_catalog.>=	tintervalge
pg_catalog.>	tintervalgt
pg_catalog.<=	tintervalle
pg_catalog.#=	tintervalleneq
pg_catalog.#>=	tintervallenge
pg_catalog.#>	tintervallengt
pg_catalog.#<=	tintervallenle
pg_catalog.#<	tintervallenlt
pg_catalog.#<>	tintervallenne
pg_catalog.<	tintervallt
pg_catalog.<>	tintervalne
pg_catalog.&&	tintervalov
pg_catalog.~=	tintervalsame
pg_catalog.

Features and Objects Removed in WarehousePG 7 ​

Removed Features ​

Removed Objects ​

Removed Tables and Views ​

Removed Columns ​

Removed Functions ​

Removed Types and Composite Types ​

Removed Operators ​