You might scrap all BEGIN/COMMIT/ROLLBACK stmts, and run your upgrade_all.sql as
psql --single-transaction -f upgrade_all.sql
Στις Monday 03 October 2011 12:36:58 ο/η Anssi Kääriäinen έγραψε:
> I am having the following problem: I have upgrade scripts which are
> runnable one-by-one. I will also
I am having the following problem: I have upgrade scripts which are
runnable one-by-one. I will also want to run all of them together. Example:
table1.sql:
begin;
alter table table1 add column new_col1;
alter table table1 add column new_col2;
commit;
table2.sql:
begin;
alter table table2 add co