On 07/26/2018 03:01 PM, Dimitri Maziuk wrote:
> On 07/26/2018 04:39 PM, Adrian Klaver wrote:
>
>> The thing that has me somewhat confused is:
>>
>> ERROR: permission denied for schema macromolecules
>>
>> I would thought the replication user could access that.
>
> The more I look at the errors, the less sense it all makes.
Sounds like my problems:)
>
> Let me ask a different question: if I drop and re-create a published
> table on the publisher without doing anything to the publication and
> subscription, what happens?
Take a look at:
https://www.postgresql.org/docs/10/static/sql-alterpublication.html
>
> Do I need to re-create the publication when I re-create the table?
>
--
Adrian Klaver
adrian.klaver@aklaver.com