<div class="gmail_quote">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.<br>
<br>I don't think I need any special hstore functionality, the normal 8.3 version should be sufficient. Can somebody please run the original hstore.sql? Hopefully that will be enough to get things working.<br><br>osmosisci@gauss:/osm/osmosis-continuous-integration/database/install$ psql -f /usr/share/postgresql/8.3/contrib/hstore.sql osmosisci_pgsql06 SET<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:6: ERROR: type "hstore" already exists<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:11: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:16: ERROR: permission denied for language c<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:23: ERROR: function hstore_in(cstring) does not exist<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:28: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:34: ERROR: type "hstore" is only a shell<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:39: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:44: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:52: ERROR: type "hstore" is only a shell<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:57: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:62: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:67: ERROR: permission denied for language c<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:72: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:78: ERROR: type "hstore" is only a shell<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:83: ERROR: permission denied for language c<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:88: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:97: ERROR: type "hstore" is only a shell<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:106: ERROR: type "hstore" is only a shell<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:116: ERROR: type "hstore" is only a shell<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:125: ERROR: type "hstore" is only a shell<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:130: ERROR: permission denied for language c<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:136: ERROR: function tconvert(text, text) does not exist<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:141: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:146: ERROR: permission denied for language c<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:151: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:156: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:163: ERROR: permission denied for language c<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:169: ERROR: type "ghstore" already exists<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:174: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:179: ERROR: permission denied for language c<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:185: ERROR: function ghstore_in(cstring) does not exist<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:190: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:195: ERROR: permission denied for language c<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:200: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:205: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:210: ERROR: permission denied for language c<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:215: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:220: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:238: ERROR: must be superuser to create an operator class<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:245: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:250: ERROR: permission denied for language c<br>psql:/usr/share/postgresql/8.3/contrib/hstore.sql:255: ERROR: permission denied for language c<br>
psql:/usr/share/postgresql/8.3/contrib/hstore.sql:266: ERROR: must be superuser to create an operator class<br><br>On Tue, Aug 24, 2010 at 10:34 AM, Brett Henderson <span dir="ltr"><<a href="mailto:brett@bretth.com">brett@bretth.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hmm, I got a lot of errors saying something like a C function required superuser access. I was trying to use the hstore.sql, not hstore-new.sql. I'll try again this evening and see how I go.<br>
<br><div class="gmail_quote">
2010/8/23 Sven Geggus <span dir="ltr"><<a href="mailto:lists@fuchsschwanzdomain.de" target="_blank">lists@fuchsschwanzdomain.de</a>></span><div class="im"><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>Brett Henderson <<a href="mailto:brett@bretth.com" target="_blank">brett@bretth.com</a>> wrote:<br>
<br>
> Can somebody with superuser access to PostgreSQL please install the<br>
> hstore.sql contrib module into the osmosisci_pgsql06 database?<br>
<br>
</div>I'm quite shure taht this would not need superuser access<br>
<br>
psql:/usr/share/postgresql/8.3/contrib/hstore-new.sql:13: ERROR: type "hstore" already exists<br>
<br>
Regards<br>
<br>
Sven<br></blockquote></div></div><br>
</blockquote></div><br>