Updated on 2025-06-07 GMT+08:00

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.