"ERROR: 42883: could not identify an ordering operator for type polygon"

Поиск
Список
Период
Сортировка
От Katz, Lawrence
Тема "ERROR: 42883: could not identify an ordering operator for type polygon"
Дата
Msg-id 8DFB5FC363A9674B96CC96324597106503E37529@EVS3.NAM.CI.ROOT
обсуждение исходный текст
Список pgsql-general
Hi,

I'm trying to setup Bucardo to do a master-master replication between two PostgreSQL servers.  However, it looks like
whenit tries to execute a query involving DISTINCT and a column with a data type of "polygon", the following error is
thrownby PostgreSQL: 

ERROR:  42883: could not identify an ordering operator for type polygon

I assume a default operator class for polygon needs to be defined using "CREATE OPERATOR CLASS"
(http://www.postgresql.org/docs/8.1/static/sql-createopclass.html). Does anyone have an example of an appropriate
operatorclass definition for this data type? 

Thanks,
Lawrence

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: SPI_ERROR_TRANSACTION [PostgreSQL 8.3]
Следующее
От: Christine Penner
Дата:
Сообщение: Restore Crashes Postgres