| From: | legrand legrand <legrand_legrand(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Partitioning Column needs to be Key |
| Date: | 2020-02-19 10:11:16 |
| Message-ID: | 1582107076773-0.post@n3.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hello,
this is not supported yet.
See: https://www.postgresql.org/docs/12/ddl-partitioning.html
that says
"Unique constraints on partitioned tables must include all the partition key
columns.
This limitation exists because PostgreSQL can only enforce uniqueness in
each partition individually."
It is because PostgreSQL doesn't have any "global index" support yet. If you
really want to partition you table on a key that is not in the partition
key, you may have a look at
www.postgresql-archive.org/PostgreSQL-11-global-index-td6032681.html
Regards
PAscal
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2020-02-19 10:47:11 | Re: [Bug Report] Week Day |
| Previous Message | Panchal, Hiren (GE Corporate, consultant) | 2020-02-19 09:44:27 | Regarding postgres driver odbc issue |