[Slony1-bugs] tab_relname not updated on slonik

[Steve Singer]

On 3/15/20 1:35 AM, Soni M via Slony1-bugs wrote:
> Hello All,
> It's slony 2.2.8, pg11, centos 7, 2 master with 2 different set and 1 
> slave holding both set.
> 
> When renaming table on a set using slonik, the table name is updated on 
> both master and slave, the tab_relname is updated on master but not on 
> slave.
> 
> The replication still works anyway.
> 


Did you rename the table via EXECUTE SCRIPT ?

If not you might consider submitting an EXECUTE SCRIPT via slonik that 
does nothing (ie just performs a select or something) to get slony to 
refresh the tab_relname.

This is mentioned in the docs at 
https://www.slony.info/documentation/2.2/ddlchanges.html in section 
3.3.2 (The documentation says you can try calling schemadocupdaterelname() )




> -- 
> Regards,
> 
> Soni Maula Harriz
> 
> _______________________________________________
> Slony1-bugs mailing list
> Slony1-bugs at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-bugs
>