Help Center> GaussDB> Distributed_3.x> Schemas> DBE_SQL_UTIL Schema> DBE_SQL_UTIL.enable_sql_patch
Updated on 2024-05-07 GMT+08:00

DBE_SQL_UTIL.enable_sql_patch

enable_sql_patch enables 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.enable_remote_sql_patch API to enable SQL patches.
Table 1 DBE_SQL_UTIL.enable_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.