4 ms·
To confirm, Timescale does not currently support upserts? INSERT ON CONFLICT ... ?
by bsg75 9y ago
To confirm, Timescale does not currently support upserts? INSERT ON CONFLICT ... ?
- RobAtticus 9y agoWe do support UPSERTs: http://docs.timescale.com/v0.8/using-timescaledb/writing-data#upsert http://docs.timescale.com/v0.8/using-timescaledb/writing-dat... There is one limitation mentioned there ("TimescaleDB does not yet support using ON CONFLICT ON CONSTRAINT with a named key") that doesn't work, and a tip that mentions requirements for the UNIQUE constraint, but these are not usually dealbreakers.