<div dir="ltr">Hi All,<br><br> The docs here <a href="http://www.slony.info/documentation/triggers.html">http://www.slony.info/documentation/triggers.html</a> says that post Postgres 8.3 version<br><br><snip><br><ul>
<li>If you take a <span class="APPLICATION">pg_dump</span> of a
<span class="PRODUCTNAME">Slony-I</span> node, and drop out the <span class="PRODUCTNAME">Slony-I</span> namespace, this now cleanly
removes <span class="emphasis"><i class="EMPHASIS">all</i></span> <span class="PRODUCTNAME">Slony-I</span> components, leaving the
database, <span class="emphasis"><i class="EMPHASIS">including its
schema,</i></span> in a
<span class="QUOTE">"pristine"</span>, consistent fashion, ready for
whatever use
may be desired. </li></ul></snip><br><br>But I see that when dumping a schema containing tables monitored by Slony, the dump still shows the log triggers on those tables.<br><br><span style="font-family: courier new,monospace;">postgres=# select version();</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> version </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">----------------------------------------------------------------------------------------------------</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> PostgreSQL 8.3.10 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.2 20081105 (Red Hat 4.3.2-7)</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"># pg_dump --schema-only --schema pgbench -p 5433 -U postgres | grep "CREATE TRIGGER"</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">CREATE TRIGGER _pgbench_logtrigger_1</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">CREATE TRIGGER _pgbench_logtrigger_2</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">CREATE TRIGGER _pgbench_logtrigger_3</span><br style="font-family: courier new,monospace;">
<br>So is that statement in the docs incorrect, or is this a regression?<br><br>Best regards,<br>-- <br>gurjeet.singh<br>@ EnterpriseDB - The Enterprise Postgres Company<br><a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br>
<br>singh.gurjeet@{ gmail | yahoo }.com<br>Twitter/Skype: singh_gurjeet<br><br>Mail sent from my BlackLaptop device<br>
</div>