ethereum-etl-postgres icon indicating copy to clipboard operation
ethereum-etl-postgres copied to clipboard

Missing unique constraints

Open infinidi4s opened this issue 3 years ago • 0 comments

Hi!

I don't have time to do a pull request yet, I'm just testing it out quickly, but this was missing in SQL for me for streaming to work:

alter table logs add constraint log_pair_uq unique (log_index, transaction_hash);
alter table token_transfers add constraint token_transfers_pair_uq unique (log_index, transaction_hash);

This fixed it, thank you for your work! :)

infinidi4s avatar Apr 16 '21 22:04 infinidi4s