[postgres-xl-bugs] According to ctid to perform delete operation prompt error

刘攀 leo.liu at postgresdata.com
Fri Jan 5 01:57:39 PST 2018

Hi PostgreSQL-XL,

We deployed postgres-xl-9.5r1.6, but we ran into a problem with the delete operation:
psql (PGXL 9.5r1.6, based on PG 9.5.8 (Postgres-XL 9.5r1.6))
Type "help" for help.
testdb=# create table trends(a text, itemid int);
testdb=# delete from trends where ctid = any(array(select ctid from trends where itemid=26978 limit 5000));
ERROR:  could not perform TID scan on remote relation
testdb=# delete from trends where ctid in (select ctid from trends where itemid = 26978 limit 5000);
ERROR:  could not plan this distributed delete
DETAIL:  correlated or complex DELETE is currently not supported in Postgres-XL.
However, the same operation, but in pgxc-1.2.1 can perform successfully.
These two delete operations are sent by zabbix software, because there is a lot of historical data in the environment, so hope to bulk delete by ctid.
So I would like to ask, is there any way to achieve a similar operation.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-bugs-postgres-xl.org/attachments/20180105/7a5545a3/attachment.html>

More information about the postgres-xl-bugs mailing list