Hi Glen

The problem is with table 9, not set 9. You can see which table that
refers to by looking in _gz_admin.sl_table.

The error is on alterTableRestore() function which is the part that
tries to restore the table to state it was in before slony was added.
This means putting back any rules and triggers that slony had "hidden".
When I see this problem its because I have put a new rule on the table
since slony was added, and the restore function doesn't know what to do
with it. Check if your table has any rules or triggers and delete them
(except the slony trigger) and make sure any rules it would be trying to
add back are still applicable. i.e. you haven't removed any of the
columns or tables they referred to. You can see which these are by
doing: "select * from pg_rules where tablename like '<TABLENAME>_*'".
The tablename you are looking for is actually
<tablename>_<primarykeyname>. If you have set up primary keys on your
tables by just creating one of the columns with PRIMARY KEY suffix the
tablename will be '<tablename>_pkey' E.g. if table 9 is called testdata
select where tablename='testdata_pkey'.

Hope this helps you clear it up,
Vicki.


 

-----Original Message-----
From: slony1-general-bounces at gborg.postgresql.org
[mailto:slony1-general-bounces at gborg.postgresql.org] On Behalf Of Glen
Eustace
Sent: 04 April 2006 06:19
To: slony1-general at gborg.postgresql.org
Subject: [Slony1-general] Manually removing slony

Slony seems to have packed a sad for us and I am trying to start over.
I can not uninstall from the master as slony tells me there is an error
with a 'set 9', which I don't recall ever creating.  It certainly isn't
in the table of sets.

<stdin>:8: PGRES_FATAL_ERROR select "_gz_admin".uninstallNode();  -
ERROR:  Slony-I: Table with id 9 not found
CONTEXT:  SQL statement "SELECT  "_gz_admin".alterTableRestore( $1 )"
PL/pgSQL function "uninstallnode" line 14 at perform

How can I clean up my database by hand so that I can re-install ?
-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 27 5 424 015, Web: www.godzone.net.nz

"A Ministry specialising in providing low-cost professional Internet
Services to NZ Christian Churches, Ministries and Organisations"

_______________________________________________
Slony1-general mailing list
Slony1-general at gborg.postgresql.org
http://gborg.postgresql.org/mailman/listinfo/slony1-general


This message should be regarded as confidential. If you have received this 
email in error please notify the sender and destroy it immediately.
Statements of intent shall only become binding when confirmed in hard copy 
by an authorized signatory.