Greenplum Database 6 has deprecated several database objects. These changes can effect the successful upgrade from one major version to another. Review these objects when using Geenplum Upgrade, or Greenplum Backup and Restore. This topic highlight these changes.

• Deprecated Relations
• Deprecated Columns
• Deprecated Functions and Procedures
• Deprecated Types, Domains, and Composite Types
• Deprecated Operators

Parent topic: Greenplum Database Reference Guide

Deprecated Relations

The following list includes the Greenplum Database 6 deprecated relations.

• gp_toolkit.__gp_localid
• gp_toolkit.__gp_masterid
• pg_catalog.gp_configuration
• pg_catalog.gp_db_interfaces
• pg_catalog.gp_fault_strategy
• pg_catalog.gp_global_sequence
• pg_catalog.gp_interfaces
• pg_catalog.gp_persistent_database_node
• pg_catalog.gp_persistent_filespace_node
• pg_catalog.gp_persistent_relation_node
• pg_catalog.gp_persistent_tablespace_node
• pg_catalog.gp_relation_node
• pg_catalog.pg_autovacuum
• pg_catalog.pg_filespace
• pg_catalog.pg_filespace_entry
• pg_catalog.pg_listener
• pg_catalog.pg_window

Deprecated Columns

The following list includes the Greenplum Database 6 deprecated columns.

• gp_toolkit.gp_resgroup_config.proposed_concurrency
• gp_toolkit.gp_resgroup_config.proposed_memory_limit
• gp_toolkit.gp_resgroup_config.proposed_memory_shared_quota
• gp_toolkit.gp_resgroup_config.proposed_memory_spill_ratio
• gp_toolkit.gp_workfile_entries.current_query
• gp_toolkit.gp_workfile_entries.directory
• gp_toolkit.gp_workfile_entries.procpid
• gp_toolkit.gp_workfile_entries.state
• gp_toolkit.gp_workfile_entries.workmem
• gp_toolkit.gp_workfile_usage_per_query.current_query
• gp_toolkit.gp_workfile_usage_per_query.procpid
• gp_toolkit.gp_workfile_usage_per_query.state
• information_schema.triggers.condition_reference_new_row
• information_schema.triggers.condition_reference_new_table
• information_schema.triggers.condition_reference_old_row
• information_schema.triggers.condition_reference_old_table
• information_schema.triggers.condition_timing
• pg_catalog.gp_distribution_policy.attrnums
• pg_catalog.gp_segment_configuration.replication_port
• pg_catalog.pg_aggregate.agginvprelimfn
• pg_catalog.pg_aggregate.agginvtransfn
• pg_catalog.pg_aggregate.aggordered
• pg_catalog.pg_aggregate.aggprelimfn
• pg_catalog.pg_am.amcanshrink
• pg_catalog.pg_am.amgetmulti
• pg_catalog.pg_am.amindexnulls
• pg_catalog.pg_amop.amopreqcheck
• pg_catalog.pg_authid.rolconfig
• pg_catalog.pg_authid.rolcreaterexthdfs
• pg_catalog.pg_authid.rolcreatewexthdfs
• pg_catalog.pg_class.relfkeys
• pg_catalog.pg_class.relrefs
• pg_catalog.pg_class.reltoastidxid
• pg_catalog.pg_class.reltriggers
• pg_catalog.pg_class.relukeys
• pg_catalog.pg_database.datconfig
• pg_catalog.pg_exttable.fmterrtbl
• pg_catalog.pg_proc.proiswin
• pg_catalog.pg_resgroupcapability.proposed
• pg_catalog.pg_rewrite.ev_attr
• pg_catalog.pg_roles.rolcreaterexthdfs
• pg_catalog.pg_roles.rolcreatewexthdfs
• pg_catalog.pg_stat_activity.current_query
• pg_catalog.pg_stat_activity.procpid
• pg_catalog.pg_stat_replication.procpid
• pg_catalog.pg_tablespace.spcfsoid
• pg_catalog.pg_tablespace.spclocation
• pg_catalog.pg_tablespace.spcmirlocations
• pg_catalog.pg_tablespace.spcprilocations
• pg_catalog.pg_trigger.tgconstrname
• pg_catalog.pg_trigger.tgisconstraint

Deprecated Functions and Procedures

The following list includes the Greenplum Database 6 deprecated functions and procedures.

• gp_toolkit.__gp_aocsseg
• gp_toolkit.__gp_aocsseg_history
• gp_toolkit.__gp_aocsseg_name
• gp_toolkit.__gp_aoseg_history
• gp_toolkit.__gp_aoseg_name
• gp_toolkit.__gp_aovisimap
• gp_toolkit.__gp_aovisimap_entry
• gp_toolkit.__gp_aovisimap_entry_name
• gp_toolkit.__gp_aovisimap_hidden_info
• gp_toolkit.__gp_aovisimap_hidden_info_name
• gp_toolkit.__gp_aovisimap_name
• gp_toolkit.__gp_param_local_setting
• gp_toolkit.__gp_workfile_entries_f
• gp_toolkit.__gp_workfile_mgr_used_diskspace_f
• information_schema._pg_keyissubset
• information_schema._pg_underlying_index
• pg_catalog.areajoinsel
• pg_catalog.array_agg_finalfn
• pg_catalog.bmcostestimate
• pg_catalog.bmgetmulti
• pg_catalog.bpchar_pattern_eq
• pg_catalog.bpchar_pattern_ne
• pg_catalog.btcostestimate
• pg_catalog.btgetmulti
• pg_catalog.btgpxlogloccmp
• pg_catalog.btname_pattern_cmp
• pg_catalog.btrescan
• pg_catalog.contjoinsel
• pg_catalog.cume_dist_final
• pg_catalog.cume_dist_prelim
• pg_catalog.dense_rank_immed
• pg_catalog.eqjoinsel
• pg_catalog.first_value
• pg_catalog.first_value_any
• pg_catalog.first_value_bit
• pg_catalog.first_value_bool
• pg_catalog.first_value_box
• pg_catalog.first_value_bytea
• pg_catalog.first_value_char
• pg_catalog.first_value_cidr
• pg_catalog.first_value_circle
• pg_catalog.first_value_float4
• pg_catalog.first_value_float8
• pg_catalog.first_value_inet
• pg_catalog.first_value_int4
• pg_catalog.first_value_int8
• pg_catalog.first_value_interval
• pg_catalog.first_value_line
• pg_catalog.first_value_lseg
• pg_catalog.first_value_macaddr
• pg_catalog.first_value_money
• pg_catalog.first_value_name
• pg_catalog.first_value_numeric
• pg_catalog.first_value_oid
• pg_catalog.first_value_path
• pg_catalog.first_value_point
• pg_catalog.first_value_polygon
• pg_catalog.first_value_reltime
• pg_catalog.first_value_smallint
• pg_catalog.first_value_text
• pg_catalog.first_value_tid
• pg_catalog.first_value_time
• pg_catalog.first_value_timestamp
• pg_catalog.first_value_timestamptz
• pg_catalog.first_value_timetz
• pg_catalog.first_value_varbit
• pg_catalog.first_value_varchar
• pg_catalog.first_value_xid
• pg_catalog.flatfile_update_trigger
• pg_catalog.float4_avg_accum
• pg_catalog.float4_avg_decum
• pg_catalog.float4_decum
• pg_catalog.float8_amalg
• pg_catalog.float8_avg
• pg_catalog.float8_avg_accum
• pg_catalog.float8_avg_amalg
• pg_catalog.float8_avg_decum
• pg_catalog.float8_avg_demalg
• pg_catalog.float8_decum
• pg_catalog.float8_demalg
• pg_catalog.float8_regr_amalg
• pg_catalog.get_ao_compression_ratio
• pg_catalog.get_ao_distribution
• pg_catalog.ginarrayconsistent
• pg_catalog.gincostestimate
• pg_catalog.gin_extract_tsquery
• pg_catalog.gingetmulti
• pg_catalog.gingettuple
• pg_catalog.ginqueryarrayextract
• pg_catalog.ginrescan
• pg_catalog.gin_tsquery_consistent
• pg_catalog.gist_box_consistent
• pg_catalog.gist_circle_consistent
• pg_catalog.gistcostestimate
• pg_catalog.gistgetmulti
• pg_catalog.gist_poly_consistent
• pg_catalog.gistrescan
• pg_catalog.gp_activate_standby
• pg_catalog.gp_add_global_sequence_entry
• pg_catalog.gp_add_master_standby
• pg_catalog.gp_add_persistent_database_node_entry
• pg_catalog.gp_add_persistent_filespace_node_entry
• pg_catalog.gp_add_persistent_relation_node_entry
• pg_catalog.gp_add_persistent_tablespace_node_entry
• pg_catalog.gp_add_relation_node_entry
• pg_catalog.gp_add_segment
• pg_catalog.gp_add_segment_mirror
• pg_catalog.gp_add_segment_persistent_entries
• pg_catalog.gpaotidin
• pg_catalog.gpaotidout
• pg_catalog.gpaotidrecv
• pg_catalog.gpaotidsend
• pg_catalog.gp_backup_launch
• pg_catalog.gp_changetracking_log
• pg_catalog.gp_dbspecific_ptcat_verification
• pg_catalog.gp_delete_global_sequence_entry
• pg_catalog.gp_delete_persistent_database_node_entry
• pg_catalog.gp_delete_persistent_filespace_node_entry
• pg_catalog.gp_delete_persistent_relation_node_entry
• pg_catalog.gp_delete_persistent_tablespace_node_entry
• pg_catalog.gp_delete_relation_node_entry
• pg_catalog.gp_nondbspecific_ptcat_verification
• pg_catalog.gp_persistent_build_all
• pg_catalog.gp_persistent_build_db
• pg_catalog.gp_persistent_relation_node_check
• pg_catalog.gp_persistent_repair_delete
• pg_catalog.gp_persistent_reset_all
• pg_catalog.gp_prep_new_segment
• 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_read_backup_file
• pg_catalog.gp_remove_segment_persistent_entries
• pg_catalog.gp_restore_launch
• pg_catalog.gp_statistics_estimate_reltuples_relpages_oid
• pg_catalog.gp_update_ao_master_stats
• pg_catalog.gp_update_global_sequence_entry
• pg_catalog.gp_update_persistent_database_node_entry
• pg_catalog.gp_update_persistent_filespace_node_entry
• pg_catalog.gp_update_persistent_relation_node_entry
• pg_catalog.gp_update_persistent_tablespace_node_entry
• pg_catalog.gp_update_relation_node_entry
• pg_catalog.gp_write_backup_file
• pg_catalog.gpxlogloceq
• pg_catalog.gpxloglocge
• pg_catalog.gpxloglocgt
• pg_catalog.gpxloglocin
• pg_catalog.gpxlogloclarger
• pg_catalog.gpxloglocle
• pg_catalog.gpxlogloclt
• pg_catalog.gpxloglocne
• pg_catalog.gpxloglocout
• pg_catalog.gpxloglocrecv
• pg_catalog.gpxloglocsend
• pg_catalog.gpxloglocsmaller
• pg_catalog.gtsquery_consistent
• pg_catalog.gtsvector_consistent
• pg_catalog.hashcostestimate
• pg_catalog.hashgetmulti
• pg_catalog.hashrescan
• pg_catalog.iclikejoinsel
• pg_catalog.icnlikejoinsel
• pg_catalog.icregexeqjoinsel
• pg_catalog.icregexnejoinsel
• pg_catalog.int24mod
• pg_catalog.int2_accum
• pg_catalog.int2_avg_accum
• pg_catalog.int2_avg_decum
• pg_catalog.int2_decum
• pg_catalog.int2_invsum
• pg_catalog.int42mod
• pg_catalog.int4_accum
• pg_catalog.int4_avg_accum
• pg_catalog.int4_avg_decum
• pg_catalog.int4_decum
• pg_catalog.int4_invsum
• pg_catalog.int8
• pg_catalog.int8_accum
• pg_catalog.int8_avg
• pg_catalog.int8_avg_accum
• pg_catalog.int8_avg_amalg
• pg_catalog.int8_avg_decum
• pg_catalog.int8_avg_demalg
• pg_catalog.int8_decum
• pg_catalog.int8_invsum
• pg_catalog.interval_amalg
• pg_catalog.interval_decum
• pg_catalog.interval_demalg
• pg_catalog.json_each_text
• pg_catalog.json_extract_path_op
• pg_catalog.json_extract_path_text_op
• pg_catalog.lag_any
• pg_catalog.lag_bit
• pg_catalog.lag_bool
• pg_catalog.lag_box
• pg_catalog.lag_bytea
• pg_catalog.lag_char
• pg_catalog.lag_cidr
• pg_catalog.lag_circle
• pg_catalog.lag_float4
• pg_catalog.lag_float8
• pg_catalog.lag_inet
• pg_catalog.lag_int4
• pg_catalog.lag_int8
• pg_catalog.lag_interval
• pg_catalog.lag_line
• pg_catalog.lag_lseg
• pg_catalog.lag_macaddr
• pg_catalog.lag_money
• pg_catalog.lag_name
• pg_catalog.lag_numeric
• pg_catalog.lag_oid
• pg_catalog.lag_path
• pg_catalog.lag_point
• pg_catalog.lag_polygon
• pg_catalog.lag_reltime
• pg_catalog.lag_smallint
• pg_catalog.lag_text
• pg_catalog.lag_tid
• pg_catalog.lag_time
• pg_catalog.lag_timestamp
• pg_catalog.lag_timestamptz
• pg_catalog.lag_timetz
• pg_catalog.lag_varbit
• pg_catalog.lag_varchar
• pg_catalog.lag_xid
• pg_catalog.last_value
• pg_catalog.last_value_any
• pg_catalog.last_value_bigint
• pg_catalog.last_value_bit
• pg_catalog.last_value_bool
• pg_catalog.last_value_box
• pg_catalog.last_value_bytea
• pg_catalog.last_value_char
• pg_catalog.last_value_cidr
• pg_catalog.last_value_circle
• pg_catalog.last_value_float4
• pg_catalog.last_value_float8
• pg_catalog.last_value_inet
• pg_catalog.last_value_int
• pg_catalog.last_value_interval
• pg_catalog.last_value_line
• pg_catalog.last_value_lseg
• pg_catalog.last_value_macaddr
• pg_catalog.last_value_money
• pg_catalog.last_value_name
• pg_catalog.last_value_numeric
• pg_catalog.last_value_oid
• pg_catalog.last_value_path
• pg_catalog.last_value_point
• pg_catalog.last_value_polygon
• pg_catalog.last_value_reltime
• pg_catalog.last_value_smallint
• pg_catalog.last_value_text
• pg_catalog.last_value_tid
• pg_catalog.last_value_time
• pg_catalog.last_value_timestamp
• pg_catalog.last_value_timestamptz
• pg_catalog.last_value_timetz
• pg_catalog.last_value_varbit
• pg_catalog.last_value_varchar
• pg_catalog.last_value_xid
• pg_catalog.lead_any
• pg_catalog.lead_bit
• pg_catalog.lead_bool
• pg_catalog.lead_box
• pg_catalog.lead_bytea
• pg_catalog.lead_char
• pg_catalog.lead_cidr
• pg_catalog.lead_circle
• pg_catalog.lead_float4
• pg_catalog.lead_float8
• pg_catalog.lead_inet
• pg_catalog.lead_int
• pg_catalog.lead_int8
• pg_catalog.lead_interval
• pg_catalog.lead_lag_frame_maker
• pg_catalog.lead_line
• pg_catalog.lead_lseg
• pg_catalog.lead_macaddr
• pg_catalog.lead_money
• pg_catalog.lead_name
• pg_catalog.lead_numeric
• pg_catalog.lead_oid
• pg_catalog.lead_path
• pg_catalog.lead_point
• pg_catalog.lead_polygon
• pg_catalog.lead_reltime
• pg_catalog.lead_smallint
• pg_catalog.lead_text
• pg_catalog.lead_tid
• pg_catalog.lead_time
• pg_catalog.lead_timestamp
• pg_catalog.lead_timestamptz
• pg_catalog.lead_timetz
• pg_catalog.lead_varbit
• pg_catalog.lead_varchar
• pg_catalog.lead_xid
• pg_catalog.likejoinsel
• pg_catalog.max
• pg_catalog.min
• pg_catalog.mod
• pg_catalog.name_pattern_eq
• pg_catalog.name_pattern_ge
• pg_catalog.name_pattern_gt
• pg_catalog.name_pattern_le
• pg_catalog.name_pattern_lt
• pg_catalog.name_pattern_ne
• pg_catalog.neqjoinsel
• pg_catalog.nlikejoinsel
• pg_catalog.ntile
• pg_catalog.ntile_final
• pg_catalog.ntile_prelim_bigint
• pg_catalog.ntile_prelim_int
• pg_catalog.ntile_prelim_numeric
• pg_catalog.numeric_accum
• pg_catalog.numeric_amalg
• pg_catalog.numeric_avg
• pg_catalog.numeric_avg_accum
• pg_catalog.numeric_avg_amalg
• pg_catalog.numeric_avg_decum
• pg_catalog.numeric_avg_demalg
• pg_catalog.numeric_decum
• pg_catalog.numeric_demalg
• pg_catalog.numeric_stddev_pop
• pg_catalog.numeric_stddev_samp
• pg_catalog.numeric_var_pop
• pg_catalog.numeric_var_samp
• pg_catalog.percent_rank_final
• pg_catalog.pg_current_xlog_insert_location
• pg_catalog.pg_current_xlog_location
• pg_catalog.pg_cursor
• pg_catalog.pg_get_expr
• pg_catalog.pg_lock_status
• pg_catalog.pg_objname_to_oid
• pg_catalog.pg_prepared_statement
• pg_catalog.pg_prepared_xact
• pg_catalog.pg_relation_size
• pg_catalog.pg_show_all_settings
• pg_catalog.pg_start_backup
• pg_catalog.pg_stat_get_activity
• pg_catalog.pg_stat_get_backend_txn_start
• pg_catalog.pg_stat_get_wal_senders
• pg_catalog.pg_stop_backup
• pg_catalog.pg_switch_xlog
• pg_catalog.pg_total_relation_size
• pg_catalog.pg_xlogfile_name
• pg_catalog.pg_xlogfile_name_offset
• pg_catalog.positionjoinsel
• pg_catalog.rank_immed
• pg_catalog.regexeqjoinsel
• pg_catalog.regexnejoinsel
• pg_catalog.row_number_immed
• pg_catalog.scalargtjoinsel
• pg_catalog.scalarltjoinsel
• pg_catalog.string_agg
• pg_catalog.string_agg_delim_transfn
• pg_catalog.string_agg_transfn
• pg_catalog.text_pattern_eq
• pg_catalog.text_pattern_ne

Deprecated Types, Domains, and Composite Types

The following list includes the Greenplum Database 6 deprecated types, domains, and composite types.

• gp_toolkit.__gp_localid
• gp_toolkit.__gp_masterid
• pg_catalog._gpaotid
• pg_catalog._gpxlogloc
• pg_catalog.gp_configuration
• pg_catalog.gp_db_interfaces
• pg_catalog.gp_fault_strategy
• pg_catalog.gp_global_sequence
• pg_catalog.gp_interfaces
• pg_catalog.gp_persistent_database_node
• pg_catalog.gp_persistent_filespace_node
• pg_catalog.gp_persistent_relation_node
• pg_catalog.gp_persistent_tablespace_node
• pg_catalog.gp_relation_node
• pg_catalog.gpaotid
• pg_catalog.gpxlogloc
• pg_catalog.nb_classification
• pg_catalog.pg_autovacuum
• pg_catalog.pg_filespace
• pg_catalog.pg_filespace_entry
• pg_catalog.pg_listener
• pg_catalog.pg_window

Deprecated Operators

The following list includes the Greenplum Database 6 deprecated operators.