背景:
使用fineBI外置数据库使用 Postgres-XL后 发现有些功能出现问题,比如用户编辑保存失败
数据库版本:PostgreSQL 10.6 (Postgres-XL 10r1.1) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
错误提示:
Caused by: org.postgresql.util.PSQLException: ERROR: could not plan this distributed delete
详细:correlated or complex DELETE is currently not supported in Postgres-XL
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)\n\tat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)\n\tat org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)\n\tat org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)\n\tat org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:167)
org.postgresql.jdbc.PgPreparedS