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

Row Execution Engine

GS_231100066

errmsg:not-in hashjoin optimization doesn't support row-engine.

errhint: Don't include 'notinopt' option in rewrite_rule setting.

level:ERROR

GS_231100068

errmsg:RIGHT JOIN is only supported with merge-joinable join conditions.

errhint: Try other join methods like nestloop or hashjoin.

level:ERROR

GS_231100069

errmsg:FULL JOIN is only supported with merge-joinable join conditions.

errhint: Try other join methods like nestloop or hashjoin.

level:ERROR

GS_231140004

errmsg:%s command cannot affect row a second time.

errhint: Ensure that no rows proposed for insertion within the same command have duplicate constrained values.

level:ERROR

GS_231140071

errmsg:abort transaction due to concurrent update %s %u.

errhint: Try to turn on GUC allow_concurrent_tuple_update if concurrent update is expected.

level:ERROR

GS_231180005

errmsg:cannot insert into view %s.

errhint: You need an unconditional ON INSERT DO INSTEAD rule or an INSTEAD OF INSERT trigger.

level:ERROR

GS_231180006

errmsg:cannot update view %s.

errhint: You need an unconditional ON UPDATE DO INSTEAD rule or an INSTEAD OF UPDATE trigger.

level:ERROR

GS_231180007

errmsg:cannot delete from view %s.

errhint: You need an unconditional ON DELETE DO INSTEAD rule or an INSTEAD OF DELETE trigger.

level:ERROR

GS_231240003

errmsg:transaction left non-empty SPI stack.

errhint: Check for missing \SPI_finish\ calls.

level:WARNING

GS_231240004

errmsg:subtransaction left non-empty SPI stack.

errhint: Check for missing \SPI_finish\ calls.

level:WARNING

GS_231240027

errmsg:%s is not allowed in a non-volatile function.

errhint: You can change function definition.

level:ERROR