Thanks for the response! At this point in our project, it's probably easiest for me to just slap that into our local copy of 1.1.5-RC2...unless it depends on other 1.2 stuff? It looks pretty straightforward....

Thanks again.

- DAP 

> -----Original Message-----
> From: Christopher Browne [mailto:cbbrowne at ca.afilias.info] 
> Sent: Friday, April 21, 2006 1:19 PM
> To: David Parker
> Cc: slony1-general at gborg.postgresql.org
> Subject: Re: [Slony1-general] xxid in a where clause
> 
> "David Parker" <dparker at tazznetworks.com> writes:
> > 1.1.5-RC2
> >
> > ?
> >
> > I have a single node in which I have a replication environment 
> > installed, and a replication set defined, but with no 
> subscribers to 
> > the node. As I add data, the sl_log_1 table keeps getting larger. I 
> > see messages in the slon log that the cleanup thread is 
> running, but 
> > it is not deleting from the log table.
> >
> > ?
> >
> > Trying to track this down, I'm extracting sql statements from the 
> > cleanup thread code to try running against the database, 
> but I can't 
> > seem to get the syntax correct for a SELECT statement with "where 
> > log_xid = x" - I get errors about not being able to cast xid to 
> > integer, etc. - I'm looking in the event table to get these 
> xids, but 
> > I clearly need to cast them somehow to work in the query, 
> and I can't 
> > figure out how to do this. This is probably a generic 
> postgres usage 
> > question, but I'm trying to track down the problem 
> mentioned above, so 
> > any hints would be appreciated.
> 
> I put a patch into 1.2 that addresses this, and it does so by 
> purging from sl_event.
> 
> http://gborg.postgresql.org/pipermail/slony1-commit/2006-March
> /000988.html
> 
> A reasonable thing to do, in effect, is to delete all of the 
> events except for the very last one.
> 
> We leave the last one in so that if no SYNCs run for a while, 
> you haven't lost the ability to start up subscriptions.  
> (Mumble, mumble, if things are that broken, it's not time to 
> start subscribing :-).)
> --
> output = ("cbbrowne" "@" "ca.afilias.info") 
> <http://dba2.int.libertyrms.com/> Christopher Browne
> (416) 673-4124 (land)
>