Dnia 2013-07-24, śro o godzinie 18:21 -0400, Steve Singer pisze:
> On 07/23/2013 03:27 AM, Robert Wysocki wrote:
> 
> Could the problem be with your sequences?
> 
> I was able to reproduce a test case that looked something like this
> 
> EXECUTE SCRIPT(SQL='insert into table5 (data) values ('9');', event node=1);
> 
> This worked okay on my origin giving me a row:
> 
> 7 | seven
> 8 | 9
> 
> where the first row already existed.
> 
> But when this SQL executed on the replica
> 
> COPY IN: ERROR:  duplicate key value violates unique constraint 
> "table5_pkey"
> db3:java.lang.UNIXProcess at 6542bece - DETAIL:  Key (id)=(7) already exists.
> 
> We don't update + replicate the sequence value updates at the start of a 
> EXECUTE_SCRIPT event (apparently).

This probably is what's causing it - especially that we do not replicate
this particular sequence - but I wander how is it that it worked (and is
still working on prod) with slony <= 2.0.7?

Regards,
-- 
Robert Wysocki
administrator systemów linuksowych
administrator baz danych
Grupa Unity | ul. Przedmiejska 6-10, 54-201 Wrocław
ul. Conrada 55B, 31-357 Kraków | ul. Złota 59, 00-120 Warszawa