Re: Weird query error from one of my users

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Scalia <jayknowsunix(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Weird query error from one of my users
Date: 2015-11-23 20:18:55
Message-ID: 11930.1448309935@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

John Scalia <jayknowsunix(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Mead 2015-11-23 20:20:29 Re: Weird query error from one of my users
Previous Message John Scalia 2015-11-23 19:57:51 Weird query error from one of my users