i do have the same error , make sure you have the same version of postgresql and slony on the two of yours machines . It seems solve my pb. This pb could also be solve by editing a rule in the view , as the script try to udate a view , thing not allowed . Your rule will redirect the update to the table instead of the view.(good luck anderstanding my english) ----- Original Message ----- From: "Joost Kraaijeveld" <[EMAIL PROTECTED]> To: "Cyril Pinto" <[EMAIL PROTECTED]> Cc: <[email protected]> Sent: Friday, October 27, 2006 2:27 PM Subject: Re: [Slony1-general] Error running slony_master_setup.sh createdby slony_setup.pl (Slony-I 1.1.5)
> Hi Cyril, > > Thanks for the answer. > > > On Fri, 2006-10-27 at 14:10 +0200, Cyril Pinto wrote: >> I got the same error and i've just replaced in the slony_setup.pl >> >> max (usesysid) by *max (int8(usesysid)) (do it for all insert in the >> file)* >> >> and all go well after ! > > Mmmm. I get the next error (which makes sense as pg_shadow is a view): > > ERROR: cannot insert into a view > > > > > -- > Groeten, > > Joost Kraaijeveld > Askesis B.V. > Molukkenstraat 14 > 6524NB Nijmegen > tel: 024-3888063 / 06-51855277 > fax: 024-3608416 > web: www.askesis.nl > > _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
