I received the same error with a similar setup - it seems sqlobject can't figure out the correct order to create the tables in. My solution was, like you, to create the referenced table first (in your case that would mean manually creating the 'patient' table), and then have tg-admin sql create add the rest of the tables afterwards.
It would be really nice to make sqlobject aware of restrictions like this - either by creating tables in the "correct" order or by adding the references afterwards. Regards, -Toke
