org.postgresql.util.PSQLException

No hstore extension installed.


Solutions on the web249

Solution icon of stackoverflow
No hstore extension installed.

Solution icon of github
No hstore extension installed.

Solution icon of github
No hstore extension installed.

Solution icon of web
via JIRA by Charlie Sharpsteen, 4 months ago
No hstore extension installed.

Solution icon of stackoverflow
No hstore extension installed.

Solution icon of stackoverflow
No hstore extension installed.

Solution icon of github
ERROR: could not open extension control file "/usr/share/postgresql/9.3/extension/unaccent.control": No such file or directory

Solution icon of stackoverflow
via Stack Overflow by robert trudel
, 17 hours ago
ERROR: column "fields" is of type hstore but expression is of type character varying Indice : You will need to rewrite or cast the expression. Position : 86

Solution icon of github
via GitHub by maacl
, 9 months ago
ERROR: syntax error at or near "EXTENSION" Position: 8

Stack trace

  • org.postgresql.util.PSQLException: No hstore extension installed. at org.postgresql.jdbc.PgPreparedStatement.setMap(PgPreparedStatement.java:553) at org.postgresql.jdbc.PgPreparedStatement.setObject(PgPreparedStatement.java:1036) at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.setObject(PreparedStatementJavassistProxy.java) at groovy.sql.Sql.setObject(Sql.java:4134) at groovy.sql.Sql.setParameters(Sql.java:4099) at groovy.sql.Sql.getPreparedStatement(Sql.java:4360) at groovy.sql.Sql.getPreparedStatement(Sql.java:4436) at groovy.sql.Sql.executeUpdate(Sql.java:2863) at groovy.sql.Sql.executeUpdate(Sql.java:2885)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

9 times, 5 months ago