With the OFBiz tools there are a couple of options.
1. on the check/update page in webtools you can drop and recreate all foreign keys 2. in the import use the dummy-fks option which will insert dummy records as needed with pk only values to satisfy primary key constraints
Yeah, there are various loops: self-referencing entities (A -> A) and mulit-entity loops (A->B->A; A->B->C->A; etc).
-David On Apr 14, 2007, at 12:25 AM, Jonathon -- Improov wrote:
David,Yeah, you're right. You just reminded me of the loops in the data structure (self-referencing entities?).I'll look for a way to port MySQL data directly to PostgreSQL then. Even using standard SQL shouldn't be a problem, I suppose.I think it's time I started getting in touch with PostgreSQL. Jonathon David E. Jones wrote:On Apr 13, 2007, at 9:42 PM, Jonathon -- Improov wrote:The hierarchical walk you mentioned seems like too much work, perhaps even computationally expensive. I would've preferred a dumb dump (same structure to same structure), complete with referential keys. I'm sure there are very largely similar SQL- standard features between MySQL and PostgreSQL.Actually, it's worse, it is not possible. The problem is it isn't an hierarchy, it's a graph, and this graph has loops in it.... So, yeah, an ordered traversal is impossible.-David
smime.p7s
Description: S/MIME cryptographic signature
