Re: Duplicate key violation on upsert

[Matt Magoffin <postgresql.org@xxxxxxx>]

On 27/03/2020, at 5:26 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:

Well morning and coffee helped some, but not enough to offer blinding insight. Reviewing the function above, the TimescaleDB insert block function and the overview of the TimescaleDB hypertable architecture leads me to believe there is some sort of conflict between the solarnetwork functions and the TimescaleDB hypertable actions. It is a wishy-washy answer as I do not understand the TimescaleDB architecture well enough. You might want to reach to the TimescaleDB community to see if they can offer any further insight.

Fair enough! Thank you for taking the time to look through this issue with me, I really appreciate it. I’ll reach out the the TimescaleDB folks and see what they think.

— m@