2 Feb
2011
2 Feb
'11
8:11 a.m.
On Wed, Feb 2, 2011 at 1:27 PM, Peter Cock <p.j.a.cock@googlemail.com> wrote:
Should I file a bug report?
$ sh manage_db.sh upgrade 72 -> 73...
Migration script to add 'ldda_parent_id' column to the implicitly_converted_dataset_association table.
Adding ldda_parent_id column to implicitly_converted_dataset_association table failed: SQLite does not support ALTER TABLE ADD FOREIGN KEY; see http://www.sqlite.org/lang_altertable.html done
Concerningly, although the upgrade says it fails, it looks like some of it worked: $ sh manage_db.sh db_version 73 Shouldn't each update step be one big transaction that gets rolled back to leave things in a known state (in this case, schema version 72)? Peter