Re: [OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

2008-11-04 Thread Frederik Ramm
Hi, Andy Allan wrote: Nice. Much of this I suspect is because people really, really don't understand the spatial bit of spatial databases. Many also don't understand the databases bit of spatial databases ;-) To be fair, we don't exactly exhibit a lot of database power through our API (for

Re: [OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

2008-11-04 Thread Andy Allan
On Mon, Nov 3, 2008 at 6:47 PM, Frederik Ramm [EMAIL PROTECTED] wrote: Increasingly, and I believe this is born from unreflected Wikipedia customs being applied here, people make collections or categories using relations, for example cycle network North-Rine-Westphalia containing every cycle

Re: [OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

2008-11-04 Thread Hakan Tandogan
On Tue, November 4, 2008 12:10, Andy Allan wrote: On Mon, Nov 3, 2008 at 6:47 PM, Frederik Ramm [EMAIL PROTECTED] wrote: Increasingly, and I believe this is born from unreflected Wikipedia customs being applied here, people make collections or categories using relations, for example cycle

Re: [OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

2008-11-03 Thread Daniel Silverstone
On Mon, 2008-11-03 at 09:50 +, Andy Allan wrote: Should we restrict the maximum number of relations|ways|nodes that can be *direct* members of a relation? I don't mind cascading relations, but 39000 direct members of a single relation might casue issues too. Just as a heads-up to anyone

Re: [OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

2008-11-03 Thread Brett Henderson
Jochen Topf wrote: On Sun, Nov 02, 2008 at 08:40:45PM +1100, Brett Henderson wrote: Florian Lohoff wrote: On Fri, Oct 31, 2008 at 11:17:16AM +0100, Florian Lohoff wrote: Hi, i just discovered that osmosis was not able to apply the hourly osc file starting

Re: [OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

2008-11-03 Thread Andy Allan
On Mon, Nov 3, 2008 at 12:17 AM, Shaun McDonald [EMAIL PROTECTED] wrote: On 2 Nov 2008, at 10:58, Jochen Topf wrote: [..] I think you'll have to do that until the server is changed to forbid more than x nodes on ways. Is there a problem with changing the server code to count the nodes and

Re: [OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

2008-11-03 Thread Frederik Ramm
Hi, Andy Allan wrote: Should we restrict the maximum number of relations|ways|nodes that can be *direct* members of a relation? I don't mind cascading relations, but 39000 direct members of a single relation might casue issues too. I tend to say yes, limit it in some way. People are starting

Re: [OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

2008-11-02 Thread Jochen Topf
On Sun, Nov 02, 2008 at 08:40:45PM +1100, Brett Henderson wrote: Florian Lohoff wrote: On Fri, Oct 31, 2008 at 11:17:16AM +0100, Florian Lohoff wrote: Hi, i just discovered that osmosis was not able to apply the hourly osc file starting 2008-10-29T20:00:00Z - It failed with:

Re: [OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

2008-11-02 Thread Brett Henderson
Florian Lohoff wrote: On Fri, Oct 31, 2008 at 11:17:16AM +0100, Florian Lohoff wrote: Hi, i just discovered that osmosis was not able to apply the hourly osc file starting 2008-10-29T20:00:00Z - It failed with: 2008-10-31 11:09:52 CET ERROR: smallint out of range 2008-10-31 11:09:52

Re: [OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

2008-11-02 Thread Shaun McDonald
On 2 Nov 2008, at 10:58, Jochen Topf wrote: [..] I think you'll have to do that until the server is changed to forbid more than x nodes on ways. Is there a problem with changing the server code to count the nodes and return an error if there are more than x nodes? I haven't looked at the

[OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

2008-10-31 Thread Florian Lohoff
On Fri, Oct 31, 2008 at 11:17:16AM +0100, Florian Lohoff wrote: Hi, i just discovered that osmosis was not able to apply the hourly osc file starting 2008-10-29T20:00:00Z - It failed with: 2008-10-31 11:09:52 CET ERROR: smallint out of range 2008-10-31 11:09:52 CET STATEMENT: INSERT INTO