Updated on 2023-12-22 GMT+08:00

GAUSS-00561 -- GAUSS-00570

GAUSS-00561: "views cannot be unlogged because they do not have storage"

SQLSTATE: 42601

Description: The view to be defined is set to UNLOGGED.

Solution: Do not set the view to be defined to UNLOGGED because it does not have actual storage.

GAUSS-00562: "unrecognized value for EXPLAIN option '%s': '%s'"

SQLSTATE: 22023

Description: The EXPLAIN FORMAT parameter cannot be recognized.

Solution: Ensure that the value of the EXPLAIN FORMAT parameter is TEXT, XML, JSON, or YAML.

GAUSS-00563: "unrecognized EXPLAIN option '%s'"

SQLSTATE: 42601

Description: The parameter of EXPLAIN cannot be recognized.

Solution: Ensure that the parameter of EXPLAIN is ANALYZE, VERBOSE, COSTS, BUFFERS, NODES, NUM_NODES, TIMING, CPU, DETAIL, PERFORMANCE, or FORMAT.

GAUSS-00564: "EXPLAIN option BUFFERS requires ANALYZE"

SQLSTATE: 22023

Description: ANALYZE is not specified for EXPLAIN BUFFERS.

Solution: Specify ANALYZE for EXPLAIN BUFFERS.

GAUSS-00565: "EXPLAIN option CPU requires ANALYZE"

SQLSTATE: 22023

Description: ANALYZE is not specified for EXPLAIN CPU.

Solution: Specify ANALYZE for EXPLAIN CPU.

GAUSS-00566: "EXPLAIN option DETAIL requires ANALYZE"

SQLSTATE: 22023

Description: ANALYZE is not specified for EXPLAIN DETAIL.

Solution: Specify ANALYZE for EXPLAIN DETAIL.

GAUSS-00567: "EXPLAIN option TIMING requires ANALYZE"

SQLSTATE: 22023

Description: ANALYZE is not specified for EXPLAIN TIMING.

Solution: Specify ANALYZE for EXPLAIN TIMING.

GAUSS-00568: "EXPLAIN %s requires ANALYZE"

SQLSTATE: 22023

Description: ANALYZE is not specified for EXPLAIN CREATE TABLE AS SELECT or EXPLAIN SELECT INTO.

Solution: Specify ANALYZE for EXPLAIN CREATE TABLE AS SELECT or EXPLAIN SELECT INTO.

GAUSS-00569: "no tlist entry for key %d"

SQLSTATE: XX000

Description: The generated plan is incorrect.

Solution: Contact technical support.

GAUSS-00570: "cache lookup failed for index %u"

SQLSTATE: XX000

Description: Indexes fail to be found in the system catalog cache.

Solution: Ensure that the index names are correct.