Sun May 16 05:22:38 PDT 2010
- Previous message: [Slony1-bugs] [Bug 122] bad error message: subscribe a set with no paths to a dropped node
- Next message: [Slony1-bugs] [Slony1-general] Slony triggers included in pg_dump
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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-Inamespace, 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.
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-bugs/attachments/20100516/fabd4530/attachment.htm
- Previous message: [Slony1-bugs] [Bug 122] bad error message: subscribe a set with no paths to a dropped node
- Next message: [Slony1-bugs] [Slony1-general] Slony triggers included in pg_dump
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-bugs mailing list