Mark Steben mark.steben at drivedominion.com
Thu Jun 23 10:44:46 PDT 2016
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 


More information about the Slony1-general mailing list