postgresql - How to continue sql script on error? -
we have couple of migration scripts, alter schema version version.
sometimes happens, migration step (e.g. adding column table) done manually or patch installation, , migration script fails.
how prevent script stopping on error (ideally @ specific expected errors) , instead log message , go on script?
we utilize postgresql 9.1, both solution postgresql general sql solution fine.
i don't think have solution running entire script outside of transaction.
what if in situation:
do modifications metadata (drop/create table/column...) outside of transaction. do modifications info (update/insert/delete) inside transaction. sql postgresql
No comments:
Post a Comment