| From: | Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> |
|---|---|
| To: | Melanie Plageman <melanieplageman(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org, Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
| Subject: | Re: MERGE/SPLIT PARTITIONS issues/questions |
| Date: | 2026-08-12 20:56:56 |
| Message-ID: | CAN4CZFOYFN9ZhJY9i7pbnj1aAr=MA-60G1KSw3-Aj+hMgxeBeg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
> I'm worried that despite the documentation, users might find this
> surprising -- and by the time they realize it happened, it might be
> too late.
This was one of my reasons for mentioning it. Printing out at least a
WARNING for them would make them more visible (but it still has the
problem that the mistake already happened - what if the user didn't
dump the settings before splitting?), or it could be even an ERROR by
default that would require an extra clause to override. But either of
those requires at least the code to detect these issues.
My other worry is that it could be also confusing if we have silently
different behavior in 19 and 20. Let's say all of these will be
implemented in PG20 and later. And then a dba has to deal with some
merge/split on a PG19 server, and doesn't realize that some settings
are now missing, because it works differently in 20/21/... So maybe
even with support in later versions, it would require something like
INCLUDING ALL?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melanie Plageman | 2026-08-12 21:30:18 | Re: DELETE FOR PORTION OF bypasses view WITH CHECK OPTION for leftover rows |
| Previous Message | Melanie Plageman | 2026-08-12 20:48:36 | Re: MERGE/SPLIT PARTITIONS issues/questions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melanie Plageman | 2026-08-12 21:23:46 | Re: Re-read conindid under the referenced table's lock in the RI fast path |
| Previous Message | Melanie Plageman | 2026-08-12 20:48:36 | Re: MERGE/SPLIT PARTITIONS issues/questions |