1

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

enter image description here

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.

Majico
  • 111
  • 3

0 Answers0