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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kurt <wazkelzu(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: does record_eq() ignore user-defined operators?
Date: 2010-09-05 15:30:44
Message-ID: 18709.1283700644@sss.pgh.pa.us
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

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Cédric Villemain 2010-09-05 15:37:48 Re: How can I use parameters in plain sql
Previous Message Craig Ringer 2010-09-05 13:15:56 FC13 RPMs for 9.0 - on postgresql.org ftp, but not in yum repo?