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
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
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot