On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-01401 -- GAUSS-01500/ GAUSS-01491 -- GAUSS-01500

GAUSS-01491 -- GAUSS-01500

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

View PDF

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.

Parent topic: GAUSS-01401 -- GAUSS-01500

Previous topic: GAUSS-01481 -- GAUSS-01490

Next topic: GAUSS-01501 -- GAUSS-01600

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel