Help Center> GaussDB> Distributed_3.x> Schemas> DBE_SQL_UTIL Schema> DBE_SQL_UTIL.disable_sql_patch
Updated on 2024-05-07 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.

Only the initial user, sysadmin, opradmin, and monadmin have the permission to invoke this interface.

  • 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.