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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: does record_eq() ignore user-defined operators?
Дата
Msg-id 18709.1283700644@sss.pgh.pa.us
обсуждение исходный текст
Ответ на does record_eq() ignore user-defined operators?  (Kurt <wazkelzu@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Kurt
Дата:
Сообщение: does record_eq() ignore user-defined operators?
Следующее
От: Cédric Villemain
Дата:
Сообщение: Re: How can I use parameters in plain sql