<div class="gmail_quote">2010/8/24 Sven Geggus <span dir="ltr"><<a href="mailto:lists@fuchsschwanzdomain.de">lists@fuchsschwanzdomain.de</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="im">Brett Henderson <<a href="mailto:brett@bretth.com">brett@bretth.com</a>> wrote:<br>
<br>
</div><div class="im">> I've tried to run hstore.sql again and received the output listed below. I<br>
> can't run the hstore-new.sql either because it fails due to the hstore type<br>
> already existing and refuses to proceed further.<br>
<br>
</div>This is rougly the same thing that I encountered wehn trying to activate<br>
hstore-new on your database. The SQL script just complained about hstore<br>
beeing already there.<br></blockquote><div><br>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.<br><br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
So I'm afraid I can't help you with this particular database. I can however<br>
set up a new database with hstore support if you like.<br></blockquote><div><br>There's no important data in the database, so we can drop and re-create the database. It needs both postgis and hstore support.<br><br>
Brett<br><br></div></div>