Hi!

How do I create tables with cyclic references?

As an example, suppose we have two classes:

class A(SQLObject):
    b = ForeignKey('B')

class B(SQLObject):
    a = ForeignKey('A')


/me using turbogears...

I issue a: turbogears-admin.py sql create

It gives me some erros because it tries to create table A but B does not exists, so it cannot be referenced.

My suggestion is: Create all tables and then issue all the "alter table add constraint" as necessary.

--
JP