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

From Tom Lane
Subject Re: does record_eq() ignore user-defined operators?
Date
Msg-id 18709.1283700644@sss.pgh.pa.us
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

> So i provided a primitive equality operator for the XML type in schema
> pg_catalog:

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.

            regards, tom lane

pgsql-general by date:

Previous
From: Kurt
Date:
Subject: does record_eq() ignore user-defined operators?
Next
From: Cédric Villemain
Date:
Subject: Re: How can I use parameters in plain sql