[GENERAL] partitioning : replicate_partition doesn't seem to be working

2008-10-18 Thread Ow Mun Heng
Quoted from http://www.nabble.com/Group-Sets-For-Replication-w--Partition-d19369646.html Basically, what you would need to do, weekly, is to run a slonik execute script script where the SQL script consists of something similar to what's in tests/testpartition/gen_ddl_sql.sh: - create the

Re: [GENERAL] partitioning : replicate_partition doesn't seem to be working

2008-10-18 Thread Ow Mun Heng
Hmm... seems like a SNAFU on my part. I didn't know that I need to execute it using EXECUTE SCRIPT via slonik. I was doing it via pgadmin psql. Reading this : http://lists.slony.info/pipermail/slony1-general/2008-October/008929.html and trying it found the issue. Thanks and sorry for the