Re: Publication/Subscription Questions

2018-07-28 Thread Adrian Klaver
On 07/27/2018 01:34 AM, xOChilpili wrote: Hi everyone, Im just testing/learning how subscriptions and publications work, then this is what i have done until now: Server A : create database test_pubsubs; create table foo(  id_foo serial not null primary key, foo varchar(20) not null ​);​ ins

Re: Publication/Subscription Questions

2018-07-28 Thread Christophe Pettus
> On Jul 27, 2018, at 01:34, xOChilpili wrote: > > Why ? If i remove rows, from Server B and refresh publication, why data is > not re-sync ? ALTER SUBSCRIPTION ... REFRESH PUBLICATION doesn't do another initial copy of the data for existing tables in the publication. Its function is to add

Publication/Subscription Questions

2018-07-28 Thread xOChilpili
Hi everyone, Im just testing/learning how subscriptions and publications work, then this is what i have done until now: Server A : create database test_pubsubs; create table foo( id_foo serial not null primary key, foo varchar(20) not null ​);​ insert into foo values(1,'foo'); insert into foo v