Delete Matching Database Rows - Postgresql

Support
1

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

image
image.png651×541 28.6 KB

2

I think I answered it myself. Panoply DW uses AWS redshift. It looks like this has been discontinued at first look
https://docs.aws.amazon.com/redshift/latest/dg/r_correlated_subqueries.html

3

Hi Adam,

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.