Help Center> GaussDB> Distributed_8.x> Schemas> DBE_SQL_UTIL Schema> DBE_SQL_UTIL.disable_sql_patch
Updated on 2024-06-03 GMT+08:00

DBE_SQL_UTIL.disable_sql_patch

disable_sql_patch disables SQL patches on the connected CN and returns whether the execution is successful, as described in Table 1.

Only the initial user, sysadmin, opradmin, and monadmin have the permission to call it.

  • SQL patches are not shared among CNs and need to be executed on each CN.
  • If load balancing is enabled or a CN needs to be specified, you are advised to use the DBE_SQL_UTIL.disable_remote_sql_patch API to disable SQL patches.
Table 1 DBE_SQL_UTIL.disable_sql_patch input parameters and return values

Parameter

Type

Description

patch_name

IN name

Patch name.

result

OUT bool

Specifies whether this operation is successful.