I have a table in postgresql where I’m going to delete the rows not returned
Error: XX000: This type of correlated subquery pattern is not supported due to internal error
Source: action “Delete matching database rows”, module “BEGIN”, table “Bridge - Push Changes - mjc_item”
Any thoughts on this? I’m trying to determine if internal error is internal on EM or interal on the DB. I assume it is on the DB side
I think I answered it myself. Panoply DW uses AWS redshift. It looks like this has been discontinued at first look
If you are using an ODBC connector, you can try to switch to the Redshift dialect.
This way you’ll be able to use “Delete matching DB rows” action with one restriction - matched EasyMorph columns should not contain empty values.