[OSM-dev] Adding a table to osm2pgsql (and a couple utility patches) [patch]

2011-01-18 Thread Phil! Gold
I don't see an email address in the osm2pgsql source, so I'm just sending this here; if there's a better destination, please let me know. I think it would be really useful to have a table that tracks relation membership so you can do JOINs to get the components of relations, so I added one to

Re: [OSM-dev] Adding a table to osm2pgsql (and a couple utility patches) [patch]

2011-01-18 Thread Phil! Gold
* Phil! Gold phi...@pobox.com [2011-01-18 11:16 -0500]: * planet-osm-member.patch And I noticed after sending that this patch incorrectly uncomments the DEBUG_PGSQL #define. Attached is the correct patch that only modifies output-pgsql.c. -- ...computer contrarian of the first order... /

Re: [OSM-dev] Adding a table to osm2pgsql (and a couple utility patches) [patch]

2011-01-18 Thread Frederik Ramm
Hi, Phil! Gold wrote: I think it would be really useful to have a table that tracks relation membership so you can do JOINs to get the components of relations, Would the planet_osm_rels table that is produced in --slim mode not have been suitable? Or asking this another way round, if I am

Re: [OSM-dev] Adding a table to osm2pgsql (and a couple utility patches) [patch]

2011-01-18 Thread Phil! Gold
* Frederik Ramm frede...@remote.org [2011-01-18 21:01 +0100]: Would the planet_osm_rels table that is produced in --slim mode not have been suitable? I tried using that table, but JOINs into the parts array were unacceptably slow, presumably because there was no index available for it. It's