On 8/16/2004 6:47 PM, Dan Carleton wrote:
> 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.

That's what I meant. We are just about to release the 7.3.7 and 7.4.4 
bugfix releases and if you do care for your data, you should be on 7.3.6 
instead of 7.3.2 by now.


Jan

> 
> 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,
>> > 


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #