an error message that I don't understand

From: Martin Mueller <martinmueller(at)northwestern(dot)edu>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: an error message that I don't understand
Date: 2025-05-02 20:24:52
Message-ID: BN6PR05MB36674534FFDF5E41A6CAFCA4C48D2@BN6PR05MB3667.namprd05.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

I get this error message:

table tid from new index tuple (32586,21) overlaps with invalid duplicate tuple at offset 120 of block 4398 in index "aacorrections_tcpreading_idx"

from an update query of the
update table 1 set columnx = ‘yes’
where table1.xmlid in (select xmlid from table2)

I have no idea what is going on or how to deal with it and will be grateful for advice

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2025-05-02 20:45:38 Re: an error message that I don't understand
Previous Message Phil Florent 2025-05-02 13:09:52 RE: Unlogged partitionned tables and hot standbys