Wed Oct 6 18:01:27 PDT 2004
- Previous message: [Slony1-general] slony causes postgresql children to die
- Next message: [Slony1-general] slony causes postgresql children to die
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Jan Wieck wrote: >> However, this is a serious bug since user defined tyes without any >> operators are of course legal in Postgres and have to be supported by >> Slony. I am working on a fix for it. > > This is fixed in REL_1_0_STABLE and HEAD, so it will be included in the > upcoming version 1.0.3. Thank you - it does seem to have fixed the crashes! :) I'm now seeing a new issue when the initial copy starts up. Slon logs this on my slave database: ---------------------------------- DEBUG1 copy_set 1 DEBUG1 remoteWorkerThread_1: connected to provider DB DEBUG2 remoteWorkerThread_1: copy table public.category_dates DEBUG2 remoteWorkerThread_1: 757207 bytes copied for table public.category_dates DEBUG2 remoteWorkerThread_1: 1.712 seconds to copy table public.category_dates DEBUG2 remoteWorkerThread_1: copy table public.categories ERROR remoteWorkerThread_1: "select "_T1".truncateTable('public.categories'); copy public.categories from stdin; " ERROR: cannot truncate a table referenced in a foreign key constraint DETAIL: Table "category_tree" references "categories" via foreign key constraint "$1". CONTEXT: PL/pgSQL function "truncatetable" line 4 at execute statement ERROR: cannot truncate a table referenced in a foreign key constraint DETAIL: Table "category_tree" references "categories" via foreign key constraint "$1". CONTEXT: PL/pgSQL function "truncatetable" line 4 at execute statement WARN remoteWorkerThread_1: data copy for set 1 failed - sleep 15 seconds ---------------------------------- Is slony unable to handle foreign key constraints? I didn't see anything about that in the docs. -Brad
- Previous message: [Slony1-general] slony causes postgresql children to die
- Next message: [Slony1-general] slony causes postgresql children to die
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list