[OSM-dev] Rendering with new osm.xml

[Jon Burgess]

On Sat, 2006-12-02 at 17:36 +0000, matthew-osm at newtoncomputing.co.uk
wrote:
> On Sat, Dec 02, 2006 at 12:02:20PM -0500, Christopher Schmidt wrote:
> >  1. The XML uses 'natural', which I thought we decided was reserved word
> >     in Postgres. Should that be 'natural_'? 
> 
> Heh, this isn't PostgreSQL's fault, as seems to be the general impression most
> people have around here; it's actually part of SQL99 I believe, just the not
> many other database actually include it.
> 
> The word "natural" allows you to do
> 
>   select name, address, department
>   from employees
>   natural join departments;
> 
> instead of
> 
>   select name, address, department
>   from employees
>   inner join departments
>   on employees.deptid = departments.deptid;
> 
> The way to get around the problem, as with all reserved words, is to use double
> quotes around the word, i.e.
> 
>   select "natural"
>   from x
> 
> HTH,
> 

Assuming that using "natural" does not cause and undue propblems, i'm
working on fixing the immediate quoting issue in osm2pgsql output and
will then look at mapnik + osm.xml to make sure everything works as
expected.

	Jon