Thu Jun 23 10:44:46 PDT 2016
- Previous message: [Slony1-general] slonik_drop_table issues
- Next message: [Slony1-general] slonik_drop_table issues
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.steben at 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 <vivek at khera.org> wrote: > >> >> On Thu, Jun 23, 2016 at 9:54 AM, Mark Steben < >> mark.steben at 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> -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20160623/98f6db87/attachment-0001.htm
- Previous message: [Slony1-general] slonik_drop_table issues
- Next message: [Slony1-general] slonik_drop_table issues
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list