[postgres-xl-bugs] According to ctid to perform delete operation prompt error
leo.liu at postgresdata.com
Tue Jan 9 18:25:24 PST 2018
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 PostgresXC-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...
More information about the postgres-xl-bugs