Well, I discovered that I had different versions of hstore across several databases. Some were 1.1 and others were 1.3. On the 1.3 hstore versions, the \do *.|| produces a public hstore - hstore operator, while the 1.1 shows the same as public.hstore. Maybe I just wasn't casting this far enough. On both versions that operator shows as being in the public schema. My search path does include that.
On Wed, Aug 3, 2016 at 12:25 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
John Scalia <jayknowsunix@xxxxxxxxx> writes:
> Your instruction to run "\do ||" did return a list including left arg type
> as text and right arg type as text. The list does report the schema as
> pg_catalog as opposed to the schema I'm actually working in at the moment,
Yeah, that's the built-in "text || text" operator. The question is where
is the "hstore || hstore" operator added by the hstore extension. If
you're not seeing that in \do output, then it's not in your search path.
Actually, it might be better to try "\do *.||", which should show all
operators named || regardless of which schema they are in and whether
that schema is in your path.
regards, tom lane
