Re: does record_eq() ignore user-defined operators?

From: Kurt <wazkelzu(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: does record_eq() ignore user-defined operators?
Date: 2010-09-07 07:59:48
Message-ID: 4C85F0F4.70706@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kurt <wazkelzu(at)gmx(dot)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(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2010-09-07 08:09:36 Re: Configure default for sorting of null-values?
Previous Message Rob Gansevles 2010-09-07 07:57:20 Re: Configure default for sorting of null-values?