On 5/16/2010 8:22 AM, Gurjeet Singh wrote:
> Hi All,
> 
>     The docs here http://www.slony.info/documentation/triggers.html says 
> that post Postgres 8.3 version
> 
> <snip>
> 
>     * If you take a pg_dump of a Slony-I node, and drop out the Slony-I
>       namespace, this now cleanly removes /all/ Slony-I components,
>       leaving the database, /including its schema,/ in a "pristine",
>       consistent fashion, ready for whatever use may be desired. 
> 
> </snip>
> 
> But I see that when dumping a schema containing tables monitored by 
> Slony, the dump still shows the log triggers on those tables.

I think you misinterpret the statement.

If you take a complete dump of all schemas, restore that and THEN drop 
the slony schema, you have a pristine stand alone system as the result.

pg_dump does not exclude cross-schema definitions like those triggers. 
You will get the same for example with foreign keys. For a table in the 
schema you are dumping, that references a table in a non-dumped schema, 
pg_dump will still emit the ALTER TABLE attempting to create the constraint.


Jan

> 
> postgres=# select version();
>                                               
> version                                              
> ----------------------------------------------------------------------------------------------------
>  PostgreSQL 8.3.10 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.2 
> 20081105 (Red Hat 4.3.2-7)
> 
> # pg_dump --schema-only --schema pgbench -p 5433 -U postgres | grep 
> "CREATE TRIGGER"
> CREATE TRIGGER _pgbench_logtrigger_1
> CREATE TRIGGER _pgbench_logtrigger_2
> CREATE TRIGGER _pgbench_logtrigger_3
> 
> So is that statement in the docs incorrect, or is this a regression?
> 
> Best regards,
> -- 
> gurjeet.singh
> @ EnterpriseDB - The Enterprise Postgres Company
> http://www.enterprisedb.com
> 
> singh.gurjeet@{ gmail | yahoo }.com
> Twitter/Skype: singh_gurjeet
> 
> Mail sent from my BlackLaptop device
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Slony1-bugs mailing list
> Slony1-bugs at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-bugs


-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin