| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Sergei Kornilov <sk(at)zsrv(dot)org> |
| Cc: | Cary Huang <cary(dot)huang(at)highgo(dot)ca>, Pgsql Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Patch: Global Unique Index |
| Date: | 2022-11-18 15:06:32 |
| Message-ID: | 2187643.1668783992@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Sergei Kornilov <sk(at)zsrv(dot)org> writes:
> Do we need new syntax actually? I think that a global unique index can be created automatically instead of raising an error "unique constraint on partitioned table must include all partitioning columns"
I'm not convinced that we want this feature at all: as far as I can see,
it will completely destroy the benefits of making a partitioned table
in the first place. But if we do want it, I don't think it should be
so easy to create a global index by accident as that syntax approach
would make it. I think there needs to be a pretty clear YES I WANT TO
SHOOT MYSELF IN THE FOOT clause in the command.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2022-11-18 15:14:44 | Re: Patch: Global Unique Index |
| Previous Message | Tomas Vondra | 2022-11-18 14:53:53 | Re: CREATE UNLOGGED TABLE seq faults when debug_discard_caches=1 |