On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-01701 -- GAUSS-01800/ GAUSS-01781 -- GAUSS-01790

GAUSS-01781 -- GAUSS-01790

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

View PDF

GAUSS-01781: "cannot move objects into system schema"

SQLSTATE: 0A000

Description: Do not move objects system table space.

Solution: Check the current tablespace type. Ensure that the tablespace into which objects are to be moved is not the system tablespace.

GAUSS-01782: "improper relation name (too many dotted names): %s"

SQLSTATE: 42601

Description: The name of the table imported is invalid.

Solution: The most complex table name supported in the database is catalogname.schemaname.relname at the utmost.

GAUSS-01783: "unexpected node type in name list: %d"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-01784: "bogus PopOverrideSearchPath call"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-01785: "collation '%s' for encoding '%s' does not exist"

SQLSTATE: 42704

Description: The encoding method obtained by executing GetDatabaseEncodingName() cannot be used with NameListToString(name).

Solution: For information about character sets and corresponding encoding methods supported by the system, see Administrator Guide.

Example:

   
      postgres=# select 'a' collate "dummy";
ERROR:  collation "dummy" for encoding "UTF8" does not exist
LINE 1: select 'a' collate "dummy";
                   ^

GAUSS-01786: "conversion '%s' does not exist"

SQLSTATE: 42704

Description: Internal system error.

Solution: Contact technical support.

GAUSS-01787: "invalid list syntax"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-01788: "permission denied to create temporary tables in database '%s'"

SQLSTATE: 42501

Description: You do not have the permission to create temporary tables in the current database.

Solution: Execute the GRANT statement to grant the user the permission to access the current database. The statement is as follows:

   
      GRANT TEMPORARY on DATABASE database_name TO role_name;

For details about the GRANT syntax, see GRANT.

GAUSS-01789: "cannot create temporary tables during recovery"

SQLSTATE: 25006

Description: Temporary tables cannot be created because the database is under recovery.

Solution: Correct the status of the database first if creating a temporary table fails.

GAUSS-01790: "current user does not have privilege to role %s"

SQLSTATE: 42501

Description: You do not have the rights to manage roles.

Solution: Manage roles as a system administrator.

Parent topic: GAUSS-01701 -- GAUSS-01800

Previous topic: GAUSS-01771 -- GAUSS-01780

Next topic: GAUSS-01791 -- GAUSS-01800

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