Upgrade from 0.9.1252 to 1.0B3 using a Postgres Database

I just wanted to let you know that I didn't have serious problems going from XWiki 0.9.1252 to XWiki 1.0B3 with a Postgres database. Basically, I followed the instructions in: http://www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXWiki10Beta3 As reported earlier, you'll get an exception ("Could not execute JDBC batch update") connecting to XWiki 1.0B3 for the first time. Analyzing the error message in xwiki.log: Batch entry 0 insert into xwikidoc (XWD_FULLNAME .) SQL ERROR: null value in column "xwd_archive" violates not-null constraint leads to an easy conclusion: remove the not-null constraint from the xwd_archive column in the xwikidoc table. The SQL statement is: ALTER TABLE xwikidoc ALTER COLUMN xwd_archive DROP NOT NULL; After running this SQL statement the connection was done successfully and I could load the XAR file as described in the instructions. In my case, only one thing was different from the old XWiki. All the memberships in XWikiAllGroup were gone. Only the ADMIN user was a member. So I created a Ruby script to add all users to XWikiAllGroup in the database. This can of course also be done manually. I don't know if this works in all Postgres cases. BTW, I did at the same time a database upgrade from PG 8.1.3 to 8.2.1. Rudolf VanderLeeden SysAdmin Logic United GmbH (Germany)