U0000003: GaussDB view does not support WITH CHECK OPTION
Description
Database Type and Version
- Source database type and version: all types of the source database with views created using WITH CHECK OPTION
- Target database type and version: all GaussDB versions
Syntax Example
This error is reported because UGO does not convert WITH CHECK OPTION by default.
WITH CHECK OPTION cannot be specified for GaussDB views, for example:
CREATE OR REPLACE VIEW view_demo AS SELECT * FROM emp_t WHERE deptno = 10 WITH CASCADED CHECK OPTION;
Suggestion
Modify Support for WITH CHECK OPTION clause in CREATE VIEW statement. GaussDB database data cannot be directly modified through views. You are advised to comment out WITH CHECK OPTION.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot