cowwoc <cowwoc(at)bbs(dot)darktech(dot)org> writes:
> My application invokes:
> DROP EXTENSION IF EXISTS hstore CASCADE
> followed by:
> CREATE EXTENSION IF NOT EXISTS hstore SCHEMA public
> and I get:
> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
> unique constraint "pg_extension_name_index"
> Detail: Key (extname)=(hstore) already exists.
That's bizarre. It sounds like there's something corrupt about your
pg_extension system catalog. Does "select * from pg_extension" show
reasonable-looking data? If so, try "REINDEX TABLE pg_extension".
regards, tom lane