Hi Amit,
> From: Amit Kapila <amit.kapil...@gmail.com> > > > Hi, > > > > > > I have a couple of questions. > > > > > > Q1. > > > > > > What happens if the subscriber already has some tables present? For > > > example, I did not see the post saying anything like "Only if the > > > table does not already exist then it will be created". > > > > > My assumption was the if subscriber is doing initial schema sync , It > > does not have any conflicting database objects. > > > > Can't we simply error out in such a case with "obj already exists"? > This would be similar to how we deal with conflicting rows with unique/primary > keys. Right this is the default behaviour , We will run pg_restore with --single_transaction, So if we get error while executing a create table the whole pg_restore will fail and user will notified. Regards Sachin
