Tuesday 15 April 2014

postgresql 9.2.4 hstore search keys Unknown operator -


Can not be used? Operator Works fine with Postgresql 9.1.9 (development), fails on 9.2.4 (output)

  test = # SELECT 'a = & gt; 1, b = & gt; 2 ': hstore? | ARRAY ['B', 'C']; Error: Operator does not exist: hstore? | Text [] Line 1: Selection 'A = & gt; 1, b = & gt; 2 ': hstore? ARRAY ['B', 'C']; ^ Hint: An operator does not match given given name and logic type (fairs). You may need to explicitly enter   

hstore is installed

  test = create # extension extension; Error: type "hstore" already exists    

Extension from error message Hstore indicates that you do not actually have extension hstore installed, just a few parts of it (otherwise the error message will be The extension "hstore" already exists .) Then I suggest that you fix your hstore installation To do this, you can create unpacked from expansion hustore. If not, you have to do manual surgery to remove or add missing parts.

No comments:

Post a Comment