Updated on 2024-03-15 GMT+08:00

GAUSS-01491 -- GAUSS-01500

GAUSS-01491: "extension '%s' already exists"

SQLSTATE: 42710

Description: During CREATE EXTENSION execution, the specified EXTENSION already exists.

Solution: During CREATE EXTENSION execution, ensure that the specified EXTENSION does not exist unless the condition if not exists is specified.

GAUSS-01492: "nested CREATE EXTENSION is not supported"

SQLSTATE: 0A000

Description: During CREATE EXTENSION execution, nesting EXTENSIONs exist in the SQL statement.

Solution: During CREATE EXTENSION execution, do not create nesting EXTENSION.

GAUSS-01494: "version to install must be specified"

SQLSTATE: 22023

Description: During CREATE/ALTER EXTENSION execution, the new version is not specified in the statement. The default version is not specified in the control file.

Solution: During CREATE/ALTER EXTENSION execution, specify the new version. Alternatively, specify the default version in the control file.

GAUSS-01495: "FROM version must be different from installation target version '%s'"

SQLSTATE: 22023

Description: During CREATE EXTENSION execution, the specified FROM version number and VERSION number are the same.

Solution: During CREATE EXTENSION execution, ensure that the specified FROM version number is different from the VERSION number.

GAUSS-01496: "extension '%s' must be installed in schema '%s'"

SQLSTATE: 0A000

Description: During CREATE EXTENSION execution, the schema specified in the WITH SCHEMA statement is different from that specified in the control file.

Solution: During CREATE EXTENSION execution, ensure that the schema specified in the WITH SCHEMA statement is the same as that specified in the control file.

GAUSS-01497: "there is no default creation target"

SQLSTATE: XX000

Description: The SCHEMA option is not specified in the CREATE EXTENSION syntax, and the default SCHEMA is used, which is empty.

Solution: The default SCHEMA is empty. The current system is abnormal or the current directory of SCHEMA is deleted manually. Contact technical support.

GAUSS-01498: "required extension '%s' is not installed"

SQLSTATE: 42704

Description: During CREATE EXTENSION or ALTER EXTENSION execution, a specific EXTENSION required as specified in the control file is not installed.

Solution: Ensure that all EXTENSIONs specified in the control file are configured during CREATE EXTENSION or ALTER EXTENSION execution. Run the \dx command to view the EXTENSIONs configured.

GAUSS-01499: "cannot drop extension '%s' because it is being modified"

SQLSTATE: 55000

Description: During DROP EXTENSION execution, the EXTENSION is being modified by another session.

Solution: Ensure that the EXTENSION is not being modified by any other session during DROP EXTENSION execution.

GAUSS-01500: "pg_extension_config_dump() can only be called from an SQL script executed by CREATE EXTENSION"

SQLSTATE: 0A000

Description: pg_extension_config_dump is not executed in the SQL script of CREATE EXTENSION.

Solution: Execute pg_extension_config_dump only in the SQL script of CREATE EXTENSION.