On 10/15/06, Andreas Kretschmer <[EMAIL PROTECTED]> 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 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
