This may be well-known or uninteresting, but slony 1.1.2 fails to 
replicate from Pg 7.3.4 due to a typo ("comment comment") in rev 
1.7.2.1 of slony1_funcs.v73.sql (Sep2005?).  The typo causes a 
transaction to fail and cascades to other issues.  Jan fixed the 
typo in the patch below on Thursday, but without comment.

Ed

On Thursday November 10 2005 4:40 pm, CVS User Account wrote:
> Log Message:
> -----------
> Disable indexes by setting pg_class.relhasindex to false
> during the initial COPY on subscribing to a set. The indexes
> are rebuild via REINDEX at the end of the copy operation.
>
> Also try to truncate the relation before the copy on 8.0 and
> later. Catch an eventual exception (foreign keys) and fallback
> to a delete.
>
> Jan
>
> Tags:
> ----
> REL_1_1_STABLE
>
> Modified Files:
> --------------
>     slony1-engine/src/backend:
>         Makefile (r1.19 -> r1.19.2.1)
>         slony1_funcs.sql (r1.64.2.12 -> r1.64.2.13)
>         slony1_funcs.v73.sql (r1.7.2.1 -> r1.7.2.2)
>         slony1_funcs.v74.sql (r1.6.2.1 -> r1.6.2.2)
>     slony1-engine/src/slon:
>         remote_worker.c (r1.86.2.9 -> r1.86.2.10)
>     slony1-engine/src/slonik:
>         slonik.c (r1.42.2.2 -> r1.42.2.3)
>     slony1-engine/src/xxid:
>         Makefile (r1.17 -> r1.17.2.1)
>
> Added Files:
> -----------
>     slony1-engine/src/backend:
>         slony1_base.v80.sql (r1.1.2.1)
>         slony1_funcs.v80.sql (r1.1.2.1)
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Reply via email to