On 4/4/2006 1:18 AM, Glen Eustace wrote:

> 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 ?

As others already pointed out, it is due to the missing table 9. 
Apparently you dropped that table while the database was replicated. 
Please note that it is not recommended to execute DDL directly against a 
Slony-I replicated database. Please see the slonik command EXECUTE 
SCRIPT for details.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #