[OSM-Devserver] Request to Install Hstore In osmosisci_pgsql06

[Brett Henderson]

2010/8/24 Sven Geggus <lists at fuchsschwanzdomain.de>

> Brett Henderson <brett at bretth.com> wrote:
>
> > I've tried to run hstore.sql again and received the output listed below.
>  I
> > can't run the hstore-new.sql either because it fails due to the hstore
> type
> > already existing and refuses to proceed further.
>
> This is rougly the same thing that I encountered wehn trying to activate
> hstore-new on your database. The SQL script just complained about hstore
> beeing already there.
>

Can you try running hstore.sql instead of hstore-new.sql?  It will throw a
couple of errors due to hstore already being defined, but the remaining
steps to create functions should work.  The hstore.sql doesn't rollback on
error like hstore-new.sql.


> So I'm afraid I can't help you with this particular database. I can however
> set up a new database with hstore support if you like.
>

There's no important data in the database, so we can drop and re-create the
database.  It needs both postgis and hstore support.

Brett
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.openstreetmap.de/pipermail/devserver/attachments/20100825/f1e07676/attachment.htm>