Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-01401 -- GAUSS-01500/ GAUSS-01481 -- GAUSS-01490
Updated on 2025-03-26 GMT+08:00
View PDF
Share

GAUSS-01481 -- GAUSS-01490

GAUSS-01481: "parameter '%s' cannot be set in a secondary extension control file"

SQLSTATE: 42601

Description: During CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related function execution, the default_version or directory parameter is specified in the secondary control file.

Solution: Do not specify the default_version or directory parameter in the secondary control file during CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related system function execution.

GAUSS-01482: "parameter '%s' requires a Boolean value"

SQLSTATE: 22023

Description: During CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related function execution, the relocatable/sysadmin parameter lacks a specified Boolean value in the control file.

Solution: Specify a Boolean value for the relocatable/sysadmin parameter in the control file during CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related function execution.

GAUSS-01483: "'%s' is not a valid encoding name"

SQLSTATE: 42704

Description: During CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related function execution, the encoding parameter lacks a valid specified encoding name in the control file.

Solution: Specify a valid encoding name for the encoding parameter in the control file during CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related function execution.

GAUSS-01484: "parameter '%s' must be a list of extension names"

SQLSTATE: 22023

Description: During CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related function execution, therequires parameter lacks a list of extension names in the control file.

Solution: Specify a list of extension names for the requires parameter in the control file during CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related function execution.

GAUSS-01485: "unrecognized parameter '%s' in file '%s'"

SQLSTATE: 42601

Description: During CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related function execution, the control file contains invalid specified parameters.

Solution: During CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related function execution, specify only the following parameters: directory, default_version, module_pathname, comment, schema, relocatable, sysadmin, encoding, and requires.

GAUSS-01486: "parameter 'schema' cannot be specified when 'relocatable' is true"

SQLSTATE: 42601

Description: During CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related function execution, the relocatable parameter is specified as true, and the schema parameter is also specified.

Solution: Do not specify the schema parameter if relocatable is set to true during CREATE EXTENSION, ALTER EXTENSION or other EXTENSION-related function execution.

GAUSS-01487: "transaction control statements are not allowed within an extension script"

SQLSTATE: 0A000

Description: During CREATE EXTENSION or ALTER EXTENSION execution, the SQL script contains transaction control SQL statements.

Solution: Ensure that the SQL script does not contain transaction control SQL statements during CREATE EXTENSION or ALTER EXTENSION execution.

GAUSS-01488: "permission denied to create extension '%s'"

SQLSTATE: 42501

Description: This error occurs when the EXTENSION control file is not run by the system administrator during CREATE EXTENSION execution.

Solution: Run the EXTENSION control file as the system administrator during CREATE EXTENSION execution.

GAUSS-01489: "permission denied to update extension '%s'"

SQLSTATE: 42501

Description: This error occurs when the EXTENSION control file is not run by the system administrator during ALTER EXTENSION execution.

Solution: Run the EXTENSION control file as the system administrator during ALTER EXTENSION execution.

GAUSS-01490: "extension '%s' has no update path from version '%s' to version '%s'"

SQLSTATE: 22023

Description: The update path specified for CREATE EXTENSION or ALTER EXTENSION does not exist.

Solution: Ensure that the name and path of the SQL files (for earlier and later versions) specified for CREATE EXTENSION or ALTER EXTENSION are correct if FROM old-version and UPDATE TO new-version are contained in the statements.