Objects Deprecated in Greenplum 6

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.

oprname	oprcode
pg_catalog.#>	json_extract_path_op
pg_catalog.#>>	json_extract_path_text_op
pg_catalog.%	int42mod
pg_catalog.%	int24mod
pg_catalog.<	gpxlogloclt
pg_catalog.<=	gpxloglocle
pg_catalog.<>	gpxloglocne
pg_catalog.=	gpxlogloceq
pg_catalog.>	gpxloglocgt
pg_catalog.>=	gpxloglocge
pg_catalog._<=	name_pattern_le
pg_catalog._<>	name_pattern_ne
pg_catalog._<>	bpchar_pattern_ne
pg_catalog._<>	textne
pg_catalog._<	name_pattern_lt
pg_catalog.₌	name_pattern_eq
pg_catalog.₌	bpchar_pattern_eq
pg_catalog.₌	texteq
pg_catalog._>=	name_pattern_ge
pg_catalog._>	name_pattern_gt