I have a specific need to ‘fixate’ my ‘roles’ table sequence when
at migration #4, I have 28 records in my roles tables and I can manually
reset the roles_id_seq but it stands to reason that since I am doing
everything else in the migration, I might as well reset the sequence
so I tried this in my migration file…
execute 'SELECT setval ( "roles_id_seq", 0 );'
and it crashed with…
– execute(“SELECT setval ( “roles_id_seq”, 0 );”)
PGError: ERROR: column “roles_id_seq” does not exist
: SELECT setval ( “roles_id_seq”, 0 );
How do I accomplish this inside of a migration?