Re: XID Data Types

Bruce Momjian wrote:
> 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 #