Objects Deprecated in Greenplum 6

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

The following list includes the Greenplum Database 6 deprecated relations.

  • gp_toolkit.__gp_localid
  • gp_toolkit.__gp_masterid
  • gp_toolkit.__gp_masterid
  • pg_catalog.gp_configuration
  • 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
  • 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
  • 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.

Table 1. 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