Issue when using hstore

[kimaidou]

Hi,

First, thanks a lot for sharing which seems a very handy tool.

I just tried to run the SQL query to build the "highroad" views, but I encounter the following error :

"could not identify an equality operator for type hstore"

My planet_osm_line is the following (see the columns "tags" in hstore format)
CREATE TABLE planet_osm_line
(
osm_id integer,
"access" text,
"addr:housename" text,
"addr:housenumber" text,
"addr:interpolation" text,
admin_level text,
aerialway text,
aeroway text,
amenity text,
area text,
barrier text,
bicycle text,
brand text,
bridge text,
boundary text,
building text,
construction text,
covered text,
culvert text,
cutting text,
denomination text,
disused text,
embankment text,
foot text,
"generator:source" text,
harbour text,
highway text,
historic text,
horse text,
intermittent text,
junction text,
landuse text,
layer text,
leisure text,
"lock" text,
man_made text,
military text,
motorcar text,
"name" text,
"natural" text,
oneway text,
"operator" text,
population text,
power text,
power_source text,
place text,
railway text,
ref text,
religion text,
route text,
service text,
shop text,
sport text,
surface text,
toll text,
tourism text,
"tower:type" text,
tracktype text,
tunnel text,
water text,
waterway text,
wetland text,
width text,
wood text,
z_order integer,
way_area real,
tags hstore,
way geometry
)
WITH (
OIDS=FALSE
);

It seems the hstore type is not well casted ?

kimaidou

[migurski]

Huh, I've never used hstore before though I know a little about what it is and how it works. Can you paste the SQL query you tried to use?

[kimaidou]

hstore is a new type of column which can store tags, examples here
http://docs.postgresqlfr.org/8.4/hstore.html

The SQL query is the one given in the views.pgsql to drop if exists then create the high roads views.