Re: pg_dump errors - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump errors
Date
Msg-id 7442.1275587101@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump errors  (Kevin Kempter <kevink@consistentstate.com>)
Responses Re: pg_dump errors  (Kevin Kempter <kevink@consistentstate.com>)
List pgsql-admin
Kevin Kempter <kevink@consistentstate.com> writes:
> On Thursday 03 June 2010 11:18, Tom Lane wrote:
>> Bizarre ... that command really oughtn't be invoking any non-builtin
>> operator, but the OID is too high for a builtin.  What do you get from
>> "select 33639::regoperator"?

> postgres=# select 33639::regoperator
> postgres-# ;
>   regoperator
> ----------------
>  abc.=(oid,oid)
> (1 row)

So where did that come from, and why is it defined incorrectly?
(Evidently it's marked oprcanhash but there is no associated hash
opclass.)  I can hardly see a reason to define your own oid equality
operator, much less a wrong one ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Kevin Kempter
Date:
Subject: Re: pg_dump errors
Next
From: "Kevin Grittner"
Date:
Subject: Re: [ADMIN] Modificar tamaño de pg_xlog