Frederik Ramm wrote: > Iván Sánchez Ortega wrote: >>> all this should be mostly handled by the db server with appropriate >>> foreign key constraints, not by the application code >> +1 >> >> Rails guys: we're using InnoDB tables for a reason, you know. > > I'm not a foreign keys guru myself but I think it may be difficult to > have one with the relation_members as designed currently.
I have solved that by splitting the members in 3 distinct tables; but placed an explicit index so I can always retrieve the members in the order they were inserted. Stefan _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev