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
