accidentally remove a table

Question

accidentally remove a table

Closed this issue 7 years ago · 4 comments

I accidentally remove a table, when i try to generate migration script it shows this error message:
ERROR: relation "university.CoursePackageCourses" does not exist
Where: SQL statement "ALTER TABLE "university"."CoursePackageCourses" ADD COLUMN "CourseSchedulledID" INT"
PL/pgSQL function inline_code_block line 3 at SQL statement
What should i do to fix this?
Thanks

Answer 1 · 2017-09-23T17:07:07.000Z

You mean you've removed CoursePackageCourses ?
You can truncate "-DSL-".database_migration
It will rebuild everything from scratch then (this should work most of the time)

Answer 2 · 2017-09-23T17:17:14.000Z

Thanks its working

Answer 3 · 2017-09-25T04:03:56.000Z

the table is recreated but the ID is not using sequence number like other table? what should i do?
right now the id column definition is:
"ID" integer NOT NULL, -- NGS generated

Answer 4 · 2017-09-25T04:24:47.000Z

i deleted the sequences and truncated the migration table and its working now