Oddbean new post about login | logout Yep, I learned about that when I wrote my first transaction indexer. 🫠
How did you handle it? Do you reassign your own txid? Or append height or something?
I think I just let it overwrite it ignore the error as long as the block height was below the BIP34 activation at height 227,836. IIRC the UTXO of the earlier duplicate transaction is unspendable and effectively overwritten.