Greenplum Database 6 removes several database objects. These changes can effect the successful upgrade from one major version to another. Review these objects when using Greenplum Upgrade, or Greenplum Backup and Restore. This topic highlight these changes.
- Removed Relations
- Removed Columns
- Removed Functions and Procedures
- Removed Types, Domains, and Composite Types
- Removed Operators
Parent topic: Greenplum Database Reference Guide
Removed Relations
The following list includes the removed relations in Greenplum Database 6.
- 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
Removed Columns
The following list includes the removed columns in Greenplum Database 6.
- 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
Removed Functions and Procedures
The following list includes the removed functions and procedures in Greenplum Database 6.
- 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
Removed Types, Domains, and Composite Types
The following list includes the Greenplum Database 6 removed 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
Removed Operators
The following list includes the Greenplum Database 6 removed 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 |
