Help Center/ GaussDB(DWS)/ Product Bulletin/ Product Notice/ Deleted Database Interfaces
Updated on 2024-09-03 GMT+08:00

Deleted Database Interfaces

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.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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.