Displaying 1 result from an estimated 1 matches for "roles_id_seq".
2006 Jun 15
8
postgresql sequence and migrations
I have a specific need to ''fixate'' my ''roles'' table sequence when
migrating.
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
there too.
so I tried this in my migration file...
execute ''SELECT setval ( "roles_id_seq", 0 );''
and it crashed with...
-- execute("SELECT set...