Postgres Pro
Downloads
Home   >   mailing lists

Re: Weird query error from one of my users - Mailing list pgsql-admin

From Tom Lane
Subject Re: Weird query error from one of my users
Date
Msg-id 11930.1448309935@sss.pgh.pa.us
Whole thread Raw
In response to Weird query error from one of my users  (John Scalia <jayknowsunix@gmail.com>)
List pgsql-admin
Tree view 
John Scalia <jayknowsunix@gmail.com> writes:
> The psql error says: ERROR:  operator does not exist: public.hstore ->
> unknown

> I don't quite understand the error as the postgresql hstore page shows the
> "->" as a valid operator. Anyone have any ideas? And of course, the better
> question is why does it run correctly in pgAdmin?

Different search_path setting?

            regards, tom lane

pgsql-admin by date:

Previous
From: 許耀彰
Date:
Subject: Re: [BUGS] postgresql downgrade issue
Next
From: Scott Mead
Date:
Subject: Re: Weird query error from one of my users