[Bucardo-general] "ERROR: 42883: could not identify an ordering operator for type polygon"

[Katz, Lawrence]

[LWK: I posted the following to the PostgreSQL General mailing list as
well, but I'm hoping that someone else has tried to use Bucardo with
polygons.]

 

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090428/8cf9def8/attachment.html