[OSM-dev] Update to osm-new.xml

Artem Pavlenko artem at pavlenko.uklinux.net
Wed Nov 29 09:47:18 GMT 2006


Sxpert, cool!
Yes, indeed, "natural" works fine. We just have to be careful to do the 
same in osm.xml
Artem.

raphael Jacquot wrote:
> Nick Whitelegg wrote:
> > Hello Artem,
> >
> >> Nick,
> >
> >> Unfortunately, NATURAL is a reserved keyword in PostgreSQL.
> >
> > How awkward :-(
> >
> >> Perhaps we could use natural_ ??
> >
> > I guess it's the osm2pgsql.c which would need modifying, translating
> > "natural" tags to a "natural_" table?
> >
> > Nick
>
> simpler, you can use "" quotes to force it:
>
> sxpert=# create table test (
> sxpert(# "natural" text
> sxpert(# );
> CREATE TABLE
> sxpert=# \d test
>     Table "public.test"
>  Column  | Type | Modifiers
> ---------+------+-----------
>  natural | text |
>
> sxpert=#
>
>




More information about the dev mailing list