Thu Dec 20 04:36:24 PST 2012
- Previous message: [Slony1-general] Bug 111/slony 1.2.21
- Next message: [Slony1-general] unsubscribe/drop set failing
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, I made a stupid mistake (I DROPped a SCHEMA with some tables in that I was replicating with slonik), and now slonik is woefully confused: postgres at star:~$ slonik_unsubscribe_set agcensus 6 | slonik <stdin>:4: PGRES_FATAL_ERROR select "_epic_cluster".unsubscribeSet(2, 6); - ERROR: Slony-I: alterTableDropTriggers(): Table with id 13 not found CONTEXT: SQL statement "SELECT "_epic_cluster".alterTableDropTriggers(v_tab_row.tab_id)" PL/pgSQL function "unsubscribeset" line 37 at PERFORM <stdin>:7: Failed to unsubscribe node 6 from set 2 If I re-create the schema and tables, I still get this error. How can I sort this out? Thanks, Matthew -- Matthew Vernon Quantitative Veterinary Epidemiologist Epidemiology Research Unit, SRUC Inverness http://www.sruc.ac.uk/mvernon Please don't print this e-mail unless you really need to. This e-mail message is confidential to the intended recipient at the email address to which it has been addressed. If the message has been received by you in error, it may not be disclosed to or used by anyone other than the intended addressee, nor may it be copied in any way. If it is not intended for you please inform us, immediately, then delete it from your system. If the content is not about the business of the organisation then the message is not from us nor is it sanctioned by us. Anything in this e-mail or its attachments which does not relate to SRUC's or SAC Commercial Limited's official business is neither given nor endorsed by SRUC or SAC Commercial Limited. SRUC A Charitable company limited by guarantee, Scottish Charity Number: SC003712. Registered in Scotland, Company Number: SC103046 - Registered Office: Peter Wilson Building, King’s Buildings, West Mains Road, Edinburgh EH9 3JG SAC Commercial Limited, an SRUC company Registered in Scotland, Company Number: SC148684 - Registered Office: Peter Wilson Building, King’s Buildings, West Mains Road, Edinburgh EH9 3JG
- Previous message: [Slony1-general] Bug 111/slony 1.2.21
- Next message: [Slony1-general] unsubscribe/drop set failing
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list