Mmm, that's unsettling to hear; unfortunately I think we're locked into
7.3.2 by proprietary software that supports it, but maybe we can get
away with going up a minor version number.

Thanks for Slony-I and the advice.

On Mon, 2004-08-16 at 15:10, Jan Wieck wrote:
> This bug got fixed in PostgreSQL 7.3.3. And not only that one, the list 
> of fixes between 7.3.2 and 7.3.3 is scaringly long, to say the least. So 
> to be honest, I think it is a great reason to upgrade.
> 
> 
> Jan
> 
> 
> On 8/16/2004 2:34 PM, Dan Carleton wrote:
> > Hello,
> > 
> > I'm running Slony-I 1.0.1 on PostgreSQL 7.3.2, which does not appear to
> > support namespace pathing in CREATE CAST statements.  The stock
> > xxid.v73.sql was failing with syntax errors on the casting to make xid
> > and xxid interchangeable.  I got around this by putting @NAMESPACE@ in
> > search_path, and this seems to work fine, though I can't test well
> > because I don't know how to make an xid. =)
> > 
> > *** src/xxid/xxid.v73.sql	Tue Jun 15 16:27:18 2004
> > --- /usr/local/postgresql-7.3.2/share/xxid.v73.sql	Mon Aug 16 11:02:08
> > 2004
> > ***************
> > *** 37,47 ****
> >   -- Since our xxid type has special cases for values 0-3, it
> >   -- in fact IS xid, so allow implicit type casting to and from.
> >   --
> > ! CREATE CAST (xid AS @NAMESPACE at .xxid)
> >   	WITHOUT FUNCTION AS IMPLICIT;
> > ! CREATE CAST (@NAMESPACE at .xxid AS xid)
> >   	WITHOUT FUNCTION AS IMPLICIT;
> >   
> >   
> >   --
> >   -- Comparision functions for the new datatype
> > --- 37,57 ----
> >   -- Since our xxid type has special cases for values 0-3, it
> >   -- in fact IS xid, so allow implicit type casting to and from.
> >   --
> > ! 
> > ! --
> > ! -- PostgreSQL 7.3.2 doesn't appear to support namespace pathing
> > ! -- in CREATE CAST, but including our namespace in the search path 
> > ! -- seems to work.
> > ! --
> > ! 
> > ! SET search_path TO public, at NAMESPACE@;
> > ! 
> > ! CREATE CAST (xid AS xxid)
> >   	WITHOUT FUNCTION AS IMPLICIT;
> > ! CREATE CAST (xxid AS xid)
> >   	WITHOUT FUNCTION AS IMPLICIT;
> >   
> > + SET search_path TO public;
> >   
> >   --
> >   -- Comparision functions for the new datatype
> > 
> > Thanks,
> > 
-- 
Dan Carleton
Open Source Technology Engineer
HouseValues, Inc.
(425) 732-4153