On Wed, 7 Jun 2006, sophana wrote:

> I'm using sqlobject-0.7
> I'm trying to follow the sqlobject-admin documentation
>
> did a
> sqlobject-admin record -m Sql
> I can see a new table created containing the current version
> then I add a column 'foo' to one of my tables

**
You need to do another `sqlobject-admin record` at this point to record 
the changes to the schema and use the --edit flag to open and editor so 
you can write the upgrade script (SQL Alter statements) which will be used 
when you then call upgrade below.
**

> then I do
> sqlobject-admin upgrade -c <MyDataBaseURI>
> it says database is up to date, but see no change.
> sqlobject-admin status -m Sql
> says Database missing column: Foo
>
> isn't the upgrade command supposed to add the column in the database?
> Did I miss something?


_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to