Friday, September 26, 2008

[GENERAL] Slony Problem

Hi,
i have 1 master and one slave db.

when in the master i run this sql : update wspet00 set datamf=20080925
where numcar = 7123123123
in the slave slon process i have an error with this log:


update only "public"."wspet00" set datamf='20080925' where ;
" ERROR: syntax error at or near ";"
LINE 1: update only "public"."wspet00" set datamf='20080925' where ;


it's seem like the sql was truncate..any idea?

Postgres version 8.2.5 and slony 1.2.13 on windows 2003 server.

Thanks,
Francesco

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: