Sven Willenberger sven
Thu Dec 29 14:45:34 PST 2005
I am trying to create a trigger on a subscriber node's replicated table
using "EXECUTE SCRIPT" but it is bailing and causing the slon process on
the subscriber to shut down with the error:

"begin transaction; set transaction ..... PGRES_FATAL_ERROR ERROR:
Slony-I: Table with id 20 not found".

Now, table id 20 is not the table I wanted to affect (when I look up the
table name in sl_table it has an id of 13) and even so, there actually
is a different table with id 20. 

For now, how can I remove the DDL event from the sync queue so that at
least I can get the slon process running on the subscriber node again?
Then, how can I go about figuring out how slon has the completely wrong
table information ?

Sven



More information about the Slony1-general mailing list