In answer to my own question - yes the primary key index on the table itself has to match with the entry in sl_table because the function alterTableDropTriggers() runs a join requiring a match for tables, indices and schema names. I had changed the pk name a couple months back which did not change the name in sl_table, hence the 'NOT FOUND'
On Thu, Jun 23, 2016 at 12:00 PM, Mark Steben <mark.ste...@drivedominion.com > wrote: > Yes it does - only one replica being used. > Question - do the index names on the master and replica have to match? > > On Thu, Jun 23, 2016 at 11:47 AM, Vick Khera <vi...@khera.org> wrote: > >> >> On Thu, Jun 23, 2016 at 9:54 AM, Mark Steben < >> mark.ste...@drivedominion.com> wrote: >> >>> <stdin>:8: Could not drop table 140 for replication! >>> >>> >> Does that exist on all replicas? >> > > > > -- > *Mark Steben* > Database Administrator > @utoRevenue <http://www.autorevenue.com/> | Autobase > <http://www.autobase.net/> > CRM division of Dominion Dealer Solutions > 95D Ashley Ave. > West Springfield, MA 01089 > t: 413.327-3045 > f: 413.383-9567 > > www.fb.com/DominionDealerSolutions > www.twitter.com/DominionDealer > www.drivedominion.com <http://www.autorevenue.com/> > > <http://autobasedigital.net/marketing/DD12_sig.jpg> > > > > -- *Mark Steben* Database Administrator @utoRevenue <http://www.autorevenue.com/> | Autobase <http://www.autobase.net/> CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 01089 t: 413.327-3045 f: 413.383-9567 www.fb.com/DominionDealerSolutions www.twitter.com/DominionDealer www.drivedominion.com <http://www.autorevenue.com/> <http://autobasedigital.net/marketing/DD12_sig.jpg>
_______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
