Tried with
SELECT setval(ScanResults_Id_seq, (SELECT MAX("Id") from "ScanResults"), true);
and also with
ALTER SEQUENCE ScanResults_Id_seq RESTART WITH (SELECT MAX("Id") from "ScanResults");
using the sequence also in lower case but I continue to get the same error:
SQL Error [42P01]: ERROR: The relation "scanresults_id_seq" does not exist
Looking at the dependencies of the table I can see the sequence name
I'm not an expert so I've seen that this dependency has the same name of the Sequence and I just assumed It is it.
