On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-02301 -- GAUSS-02400/ GAUSS-02391 -- GAUSS-02400

GAUSS-02391 -- GAUSS-02400

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

View PDF

GAUSS-02391: "cannot change TOAST relation '%s'"

SQLSTATE: 42809

Description: The object type is incorrect. The TOAST table cannot be modified using the INSERT, UPDATE, or DELETE statement.

Solution: Modify the SQL statement.

GAUSS-02392: "cannot insert into foreign table '%s'"

SQLSTATE: 0A000

Description: The INSERT operation cannot be performed for foreign tables.

Solution: Do not perform the INSERT operation for foreign tables.

GAUSS-02393: "foreign table '%s' does not allow inserts"

SQLSTATE: 55000

Description: The INSERT operation cannot be performed for foreign tables.

Solution: Do not perform the INSERT operation for foreign tables.

GAUSS-02394: "cannot update foreign table '%s'"

SQLSTATE: 0A000

Description: The UPDATE operation cannot be performed for foreign tables.

Solution: Do not perform the UPDATE operation for foreign tables.

GAUSS-02395: "foreign table '%s' does not allow updates"

SQLSTATE: 55000

Description: The UPDATE operation cannot be performed for foreign tables.

Solution: Do not perform the UPDATE operation for foreign tables.

GAUSS-02396: "cannot delete from foreign table '%s'"

SQLSTATE: 0A000

Description: The DELETE operation cannot be performed for foreign tables.

Solution: Do not perform the DELETE operation for foreign tables.

GAUSS-02397: "foreign table '%s' does not allow deletes"

SQLSTATE: 55000

Description: The DELETE operation cannot be performed for foreign tables.

Solution: Do not perform the DELETE operation for foreign tables.

GAUSS-02398: "cannot change relation '%s'"

SQLSTATE: 42809

Description: The object type is incorrect. The object type cannot be modified using INSERT, UPDATE, or DELETE.

Solution: Modify the SQL statement.

GAUSS-02399: "cannot lock rows in sequence '%s'"

SQLSTATE: 42809

Description: The object type is incorrect. Sequence cannot be locked.

Solution: Modify the SQL statement.

GAUSS-02400: "cannot lock rows in TOAST relation '%s'"

SQLSTATE: 42809

Description: The object type is incorrect. The TOAST table cannot be locked.

Solution: Modify the SQL statement.

Parent topic: GAUSS-02301 -- GAUSS-02400

Previous topic: GAUSS-02381 -- GAUSS-02390

Next topic: GAUSS-02401 -- GAUSS-02500

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