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

GAUSS-01781 -- GAUSS-01790

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:

1
2
3
4
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:

1
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.