Help Center/ GaussDB(DWS)/ 8.2.1 or later versions/ Optimizer/ Rewriting Queries
Updated on 2023-12-22 GMT+08:00
View PDF

Rewriting Queries

GS_221100010

errmsg:column %s is of type %s but default expression is of type %s.

errhint: You will need to rewrite or cast the expression.

level:ERROR

GS_221100016

errmsg:cannot perform INSERT RETURNING on relation %s.

errhint: You need an unconditional ON INSERT DO INSTEAD rule with a RETURNING clause.

level:ERROR

GS_221100017

errmsg:cannot perform UPDATE RETURNING on relation %s.

errhint: You need an unconditional ON UPDATE DO INSTEAD rule with a RETURNING clause.

level:ERROR

GS_221100018

errmsg:cannot perform DELETE RETURNING on relation %s.

errhint: You need an unconditional ON DELETE DO INSTEAD rule with a RETURNING clause.

level:ERROR

GS_221100021

errmsg:no collation was derived for column %s with collatable type %s.

errhint: Use the COLLATE clause to set the collation explicitly.

level:ERROR

GS_221100050

errmsg:rule actions on OLD are not implemented.

errhint: Use views or triggers instead.

level:ERROR

GS_221100051

errmsg:rule actions on NEW are not implemented.

errhint: Use triggers instead.

level:ERROR

GS_221100052

errmsg:INSTEAD NOTHING rules on SELECT are not implemented.

errhint: Use views instead.

level:ERROR

GS_221100062

errmsg:cannot perform INSERT RETURNING on relation %s.

errhint: You need an unconditional ON INSERT DO INSTEAD rule with a RETURNING clause.

level:ERROR

GS_221100063

errmsg:cannot perform UPDATE RETURNING on relation %s.

errhint: You need an unconditional ON UPDATE DO INSTEAD rule with a RETURNING clause.

level:ERROR

GS_221100064

errmsg:cannot perform DELETE RETURNING on relation %s.

errhint: You need an unconditional ON DELETE DO INSTEAD rule with a RETURNING clause.

level:ERROR

GS_221110004

errmsg:there are multiple rules named %s.

errhint: Specify a relation name as well as a rule name.

level:ERROR

GS_221180006

errmsg:could not convert table %s to a view because it has triggers.

errhint: In particular, the table cannot be involved in any foreign key relationships.

level:ERROR

Parent topic: Optimizer