Address view is missing transactions when in postgresql mode

[raedah]

Lite mode shows a different RECEIVED amount. Lite mode appears to be correct.

[chappjc]

Can you identify what transactions are missing?

[raedah]

See ad7072fcf50ad2d455903a281f6ed4f280f186a624b3285e57de276be7703ac3 , one of the outputs says spent true, but does not have the link available.

[chappjc]

at least for ad7072fcf50ad2d455903a281f6ed4f280f186a624b3285e57de276be7703ac3 (and the unlinked spending txn fa377e53ef7447484c608054e8cb61fe7e4699474e22f4b8aa3e8cb097c9ca80), the cause is a PSQL not correctly adding all connected blocks from the new main chain. The others like sqlite, stakedb, and blockdata have reorg handlers that work, since they must. dcrpg needs one too.

[chappjc]

BTW, I love that this is issue #404

[raedah]

A simple way to implement this would be to verify the previous x blocks when adding a new block, and replace as necessary. x should only need to be 1 since that is the largest fork that occurs.

[chappjc]

Resolved on the address page by #489, and in the dcrpg backend driver by #580