Jan Wieck wrote:Manfred Koizar wrote:
> On Mon, 03 May 2004 13:38:45 -0400, Ericson Smith <eric@did-it.com>
> wrote:
>>didit=# select *,xmin from settings where xmin > '187167023'::xid limit 5;
>>ERROR: operator does not exist: xid > xid
> > There might be better solutions, but when I ran into the same problem,
> the age(xid) function helped at lot.
Slony contains an xxid data type that follows exactly the xid semantics. It comes with a full operator class so that you can even put indexes on xxid type columns. Shouldn't be too hard to define those operators for the builtin xid type instead.
Should we just get that into our CVS so Slony doesn't have to distribute its own?
It has to anyway, at least as long as it is supposed to be a version upgrade aid that supports replicating from 7.3.x or 7.4.x to a newer version so that the upgrade downtime reduces to a few seconds for a master->slave switchover.
Jan
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
