| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: propagating replica identity to partitions |
| Date: | 2019-02-04 18:41:13 |
| Message-ID: | 201902041841.g3od6hvkdx7k@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2019-Feb-04, Alvaro Herrera wrote:
> I'll now look more carefully at the cases involving indexes; thus far I
> was looking at the ones using FULL. Those seem to work as intended.
Yeah, that didn't work so well -- it was trying to propagate the command
verbatim to each partition, and obviously the index names did not match.
So this subcommand has to reimplement the recursion internally, as in
the attached.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-index_get_partition.patch | text/x-diff | 4.3 KB |
| v2-0002-Propagate-replica-identity-to-partitions.patch | text/x-diff | 21.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arne Roland | 2019-02-04 20:31:47 | RE: dsa_allocate() faliure |
| Previous Message | Pavel Stehule | 2019-02-04 18:12:40 | Re: proposal: plpgsql pragma statement |