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? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
