Re: does record_eq() ignore user-defined operators? - Mailing list pgsql-general

From Kurt
Subject Re: does record_eq() ignore user-defined operators?
Date
Msg-id 4C85F0F4.70706@gmx.net
Whole thread Raw
In response to does record_eq() ignore user-defined operators?  (Kurt <wazkelzu@gmx.net>)
List pgsql-general
Kurt <wazkelzu@gmx.net> writes:
 >> i'm trying to replicate tables containing XML-fields using Pg 8.4.4 and
 >> 9.0B4 with Bucardo and got:
 >> DBD::Pg::st execute failed: ERROR:  could not identify an equality
 >> operator for type xml
Tom Lane <tgl@sss.pgh.pa.us> writes:
 > You would need to create a default btree or hash opclass for xml in
 > order to persuade record_eq that the type has an equality operator.
 > It does not care about operator names

Thanks Tom, it worked with a btree operator class
wz

pgsql-general by date:

Previous
From: Henk van Lingen
Date:
Subject: Re: Forcing the right queryplan
Next
From: Craig Ringer
Date:
Subject: Re: Configure default for sorting of null-values?