savrov01/20/2020, 11:08 AM
the PK value is not reseted to 0. Is there a way to do it?
return me an error:
exec("ALTER SEQUENCE 'slots_id_seq' RESTART WITH 1")
Syntax error in SQL statement "ALTER SEQUENCE 'slots_id_seq'[*] RESTART WITH 1"; expected "identifier"
tapac01/20/2020, 12:19 PM
database do you use? Maybe it's simplier allways recreate the whole database from the ground?
savrov01/20/2020, 2:18 PM
exec("ALTER TABLE slots ALTER COLUMN id RESTART WITH 1")