Deleted Database Interfaces

Updated on 2024-12-18 GMT+08:00

View PDF

To facilitate the ongoing development and maintenance of GaussDB(DWS), a metadata sunset feature is implemented to phase out outdated GUC parameters, system functions, and system views. For the sake of preserving historical compatibility, deprecated functions and views are archived within the user-created SUNSET EXTENSION, ensuring that they do not interfere with future version upgrades.

CREATE EXTENSION SUNSET

When there are attempts to access deprecated system functions and views, an error will be displayed, indicating their non-existence. GaussDB(DWS) facilitates the creation of these legacy system functions and views using the CREATE EXTENSION SUNSET statement. This extension encapsulates the sunset functions and views, preserving their original definitions prior to sunset.

Here is how to create it:

The administrator executes the CREATE EXTENSION SUNSET command to establish the extension. This extension needs to be created only once by the user. The access permissions for the sunset functions and views remain consistent with those from the pre-sunset version.

   
    
      
      CREATE EXTENSION sunset;
CREATE EXTENSION

 \dx+ sunset
                                                                                  Objects in extension "sunset"
                                                                                        Object Description                                                               
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 function pg_delete_audit(timestamp with time zone,timestamp with time zone)
 function pg_log_comm_status()
 function pg_stat_get_realtime_info_internal(oid,oid,bigint,cstring,oid)
 function pg_stat_get_wlm_session_info_internal(oid,oid,bigint,oid)
 function pg_stat_get_wlm_session_info(oid)
 function pg_stat_get_wlm_session_iostat_info(integer)
 function pg_stat_get_wlm_statistics(integer)
 function pg_sync_cstore_delta()
 function pg_sync_cstore_delta(text)
 function pg_user_iostat(cstring)
 function pgxc_log_comm_status()
 function pgxc_pool_check()
 function signal_backend(bigint,integer)
 function update_pgjob(bigint,"char",bigint,timestamp without time zone,timestamp without time zone,timestamp without time zone,timestamp without time zone,timestamp without time zone,smallint)
 view gs_wlm_session_info_all
 view pg_session_iostat
 view pg_wlm_statistics
(17 rows)

     

   
  

Deleted Database Interfaces of the 8.3.0 Cluster Version

**Table 1** Sunset system functions and views
Type	Item	Description
Functions	pg_sync_cstore_delta(text)	Merges delta table data to the primary table in column-store mode. This function has been deprecated. It is replaced by the VACUUM DELTAMERGE xxx syntax.
	pg_sync_cstore_delta	Merges delta table data to the primary table in column-store mode. This function has been deprecated. It is replaced by the VACUUM DELTAMERGE xxx syntax.
	pgxc_pool_check	Checks whether the connection data cached in the connection pool is consistent with pgxc_node. This function has been deprecated.
	pg_delete_audit	Deletes audit logs. This function has been deprecated. Manual deletion of audit logs is not allowed.
	pg_log_comm_status	Indicates the log recording status of the internal structure of the SCTP communication layer on the current node. This function has been deprecated.
	pgxc_log_comm_status	Indicates the log recording status of the internal structure of the SCTP communication layer on all nodes. This function has been deprecated.
	signal_backend	This function has been deprecated.
	pg_stat_get_realtime_info_internal	Obtains real-time top SQL information at the query level. This function has been deprecated. It is replaced by the PGXC_WLM_SESSION_STATISTICS view.
	pg_stat_get_wlm_session_info_internal	Obtains top SQL information at the query level. This function has been deprecated. It is replaced by the pg_stat_get_wlm_realtime_session_info function.
	pg_stat_get_wlm_session_info	Obtains session information. This function has been deprecated. It is replaced by the PGXC_WLM_SESSION_INFO view.
	pg_stat_get_wlm_statistics	Obtains session information. This function has been deprecated. It is replaced by the PGXC_WLM_SESSION_INFO view.
	pg_user_iostat	Obtains the I/O information of a user. This function has been deprecated. It is replaced by the PGXC_TOTAL_USER_RESOURCE_INFO view.
	pg_stat_get_wlm_session_iostat_info	Obtains the I/O information of a query. This function has been deprecated. It is replaced by the PGXC_WLM_SESSION_STATISTICS or PGXC_WLM_SESSION_INFO view.
System views	gs_wlm_session_info_all	Obtains session information. This view has been deprecated. It is replaced by the PGXC_WLM_SESSION_INFO view.
	pg_wlm_statistics	Displays load management information after a job is complete or an exception has been handled. This view has been deprecated. It is replaced by the PGXC_WLM_SESSION_INFO view.
	pg_session_iostat	Obtains the I/O information of a session. This view has been deprecated. It is replaced by the PGXC_WLM_SESSION_STATISTICS view.

Deleted Database Interfaces of the 9.1.0 Cluster Version

**Table 2** Sunset database interfaces
Type	Item	Description
Extension	file_fdw	Local file access, which is deprecated.
External server	gsmpp_errorinfo_server	This interface is used for reading data from the import error table, but it has been discarded. Accessing the import error table no longer requires gsmpp_errorinfo_server.
Logical replication	pg_create_logical_replication_slot	Creates a logical replication slot. This has been discarded in 9.1.0.200. The logical replication feature has been discarded.
Logical replication	pg_logical_slot_peek_changes	Decodes changes without pushing them to the replication slot. This has been discarded in 9.1.0.200. The logical replication feature has been discarded.
Logical replication	pg_logical_slot_get_changes	Decodes and pushes changes to the stream replication slot. This has been deprecated in 9.1.0.200. The logical replication feature has been discarded.