search

OpenSemanticLab / osw-python

GNU Affero General Public License v3.0
3 stars 2 forks source link

Fix: ensure correct auto increment setup in timescaledb #40

Open simontaurus opened 11 months ago

simontaurus commented 11 months ago

Run

SELECT SETVAL(pg_get_serial_sequence('public.sources', 'index'), (SELECT MAX(index) FROM public.sources));

before any insert https://github.com/OpenSemanticLab/osw-python/blob/e9465c58dea518e5b200a939f6d26bc6603fcfca/src/osw/controller/database.py#L266-L271