If you have multiple migration files in a set order, you might need to artificially change the date stamp in the filename to get this to run first (or just add it to your first migration file).
I suggest moving the already made migrations, create a npx knex migrate:make tigger_updated_at them past the trigger funciton here and remake your sequence of migrations so the trigger function works first.
But if you can't roll back, you might need to do this step manually via psql.
Thankyou for the post. It was quit informative
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
For anyone confused about the triger function,
If you have multiple migration files in a set order, you might need to artificially change the date stamp in the filename to get this to run first (or just add it to your first migration file).
I suggest moving the already made migrations, create a
npx knex migrate:make tigger_updated_atthem past the trigger funciton here and remake your sequence of migrations so the trigger function works first.But if you can't roll back, you might need to do this step manually via psql.
Thankyou for the post. It was quit informative