| From: | Erik Rijkers <er(at)xs4all(dot)nl> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: logical replication - possible remaining problem |
| Date: | 2017-06-07 22:07:42 |
| Message-ID: | 1422bcecdf3451027351cf12dfa0688c@xs4all.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2017-06-07 23:18, Alvaro Herrera wrote:
> Erik Rijkers wrote:
>
>> Now, looking at the script again I am thinking that it would be
>> reasonable
>> to expect that after issuing
>> delete from pg_subscription;
>>
>> the other 2 tables are /also/ cleaned, automatically, as a
>> consequence. (Is
>> this reasonable? this is really the main question of this email).
>
> I don't think it's reasonable to expect that the system recovers
> automatically from what amounts to catalog corruption. You should be
> using the DDL that removes subscriptions instead.
You're right, that makes sense.
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2017-06-07 22:13:48 | Re: PG10 transition tables, wCTEs and multiple operations on the same table |
| Previous Message | Peter Geoghegan | 2017-06-07 22:00:22 | Re: PG10 transition tables, wCTEs and multiple operations on the same table |