I hit another Postgre foreign key related store problem.

It happens when twanager is used to add an user with a role. The
problem is with the order stuff is committed to the database.
Currently an user's role is committed to the database before the
actual user is.

The roles table has a foreign key dependence on the users table, so
postgre wants the users table populated before the roles table.

Relocating one line was enough to get things going.
Moved self._map_sroles(user) out of _map_suser() and into user_put().

user_put now looks like:

def user_put(self, user):
        suser = self._map_suser(user)
        self.session.merge(suser)
        self._map_sroles(user)
        self.session.commit()


On Jun 9, 9:18 am, tony <[email protected]> wrote:

> After many starts and stops and testing, I finally got TiddlyWeb
> running from a sqlite store eg wiki.db:
> +Windows/cygwin on local and usb drives
> +Mac Leopard on local and usb drives

Nice work. Any particular reason you used cygwin on Windows?


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"TiddlyWikiDev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/TiddlyWikiDev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to