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

From: "Katz, Lawrence" <Lawrence(dot)Katz(at)CooperIndustries(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: "ERROR: 42883: could not identify an ordering operator for type polygon"
Date: 2009-04-28 15:18:23
Message-ID: 8DFB5FC363A9674B96CC96324597106503E37529@EVS3.NAM.CI.ROOT
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm trying to setup Bucardo to do a master-master replication between two PostgreSQL servers. However, it looks like when it tries to execute a query involving DISTINCT and a column with a data type of "polygon", the following error is thrown by 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 operator class definition for this data type?

Thanks,
Lawrence

Browse pgsql-general by date

  From Date Subject
Next Message Christine Penner 2009-04-28 15:43:41 Restore Crashes Postgres
Previous Message Alvaro Herrera 2009-04-28 15:16:16 Re: SPI_ERROR_TRANSACTION [PostgreSQL 8.3]