On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00101 -- GAUSS-00200/ GAUSS-00101 -- GAUSS-00110

GAUSS-00101 -- GAUSS-00110

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

View PDF

GAUSS-00101: "table '%s' has %d columns available but %d columns specified"

SQLSTATE: 42P10

Description: The number of table columns to be queried is greater than the total number of table columns.

Solution: Ensure that the number of table columns to be queried is less than or equal to the total number of table columns.

GAUSS-00102: "too many column aliases specified for function %s"

SQLSTATE: 42P10

Description: A function alias contains more than one column.

Solution: Ensure that a function alias contains only one column.

GAUSS-00103: "relation '%s' is not partitioned table"

SQLSTATE: 42P01

Description: The table is not a partitioned table.

Solution: Before performing an operation on the table, use the system catalog to ensure that the table is a partitioned table.

GAUSS-00104: "partition '%s' of relation '%s' does not exist"

SQLSTATE: 42P01

Description: The partitioned table does not exist.

Solution: When using a partitioned table, query the pg_partition table to check whether the partitioned table exists.

GAUSS-00105: "The partition number is invalid or out-of-range"

SQLSTATE: XX000

Description: The value inserted to the partition is out of the partition range.

Solution: Ensure that the value to be inserted to a partition is within the range of the partition.

GAUSS-00106: "unsupported partition type"

SQLSTATE: XX000

Description: The partition type is not supported.

Solution: Change the partition type. Currently, row-store and column-store tables support only range partitioning.

GAUSS-00107: "relation '%s.%s' does not exist"

SQLSTATE: 42P01

Description: The table object in the specified schema does not exist.

Solution: Before using a table object, ensure that it exists.

GAUSS-00108: "relation '%s' does not exist"

SQLSTATE: 42P01

Description: The table object does not exist.

Solution: Before using a table object, ensure that it exists.

GAUSS-00109: "a column definition list is only allowed for functions returning 'record'"

SQLSTATE: 42601

Description: The column definition list (or table definition) is not allowed for functions that return values of a type other than record.

Solution: Do not use table definitions to specify return values for functions that do not return values of the record type.

GAUSS-00110: "a column definition list is required for functions returning 'record'"

SQLSTATE: 42601

Description: The column definition list (or table definition) is required for functions that return values of the record type.

Solution: Use table definitions to specify return values for functions that return values of the record type.

Parent topic: GAUSS-00101 -- GAUSS-00200

Previous topic: GAUSS-00101 -- GAUSS-00200

Next topic: GAUSS-00111 -- GAUSS-00120

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