On 10/15/06, Andreas Kretschmer <akretschmer at spamfence.net> wrote:
> Hi,
>
> I'm a new slony-user. First, it runs, great!
>
> Questions:
>
> 1. I know, a TRUNCATE are not replicated because "TRUNCATE will not run
>    any user-defined ON DELETE triggers that might exist for the tables.",
>    and i know, slony based on TRIGGERs.
>    What is the best solution to solve this problem? For instance, i have
>    an application that regulary truncate a table. If i replicate this
>    table with slony, than i run into problems...

a) modify the application to use DELETE instead of truncate and deal
with the performance issue

b) modify the application to do TRUNCATE by running a slonik EXECUTE
SCRIPT command.

> 2. I have defined some sets, which tables replicated. But how can i ask
>    slony/PostgreSQL to tell me all defined sets?

Take a look at the schema slony created in your database when you ran
INIT CLUSTER...

Drew