Ühel kenal päeval, R, 2006-04-21 kell 12:50, kirjutas David Parker: > 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.
try: where log_xid = 'x' usually postgres can input string representation of any type. -------------- Hannu > _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
