Postgres Pro
Downloads
Home   >   mailing lists

Slony Problem - Mailing list pgsql-general

From furlani.francesco@gmail.com
Subject Slony Problem
Date
Msg-id 5f8c3490-904d-4c5a-ba37-3bdd98acd759@b1g2000hsg.googlegroups.com
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: yann.dubost@gmail.com
Date:
Subject: Re: Is there a parameter to tell postgresql to not attempt to open an IPv6 socket?
Next
From: "Chen, Dongdong (GE Healthcare, consultant)"
Date:
Subject: need help of getting PK after insertRow in JDBC