[Slony1-bugs] tab_relname not updated on slonik

[Soni M]

I did rename the table, figure it out now.
I run the execute with 'execute only on' parameter.
Running the slonik execute script with  'execute only on' parameter does
not update the tab_relname.
Without the  'execute only on' parameter, it updates the tab_relname.

Thanks Steve, Cheers.

On Mon, Mar 16, 2020 at 7:09 PM Steve Singer <ssinger at afilias.info> wrote:

> 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
> >
>
>

-- 
Regards,

Soni Maula Harriz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.slony.info/pipermail/slony1-bugs/attachments/20200318/734dd321/attachment.htm>