Re: multicolumn partitioning help

2023-03-14 Thread Laurenz Albe
On Sun, 2023-03-12 at 13:59 -0400, James Robertson wrote: > I am having issues with multicolumn partitioning. For reference I am using > the following link as my guide: > https://www.postgresql.org/docs/devel/sql-createtable.html > > To demonstrate my problem, I created a simple table called huma

Re: multicolumn partitioning help

2023-03-14 Thread Justin Pryzby
On Sun, Mar 12, 2023 at 01:59:32PM -0400, James Robertson wrote: > Hey folks, > I am having issues with multicolumn partitioning. For reference I am using > the following link as my guide: > https://www.postgresql.org/docs/devel/sql-createtable.html > > Reading the documentation: "When creating

multicolumn partitioning help

2023-03-14 Thread James Robertson
Hey folks, I am having issues with multicolumn partitioning. For reference I am using the following link as my guide: https://www.postgresql.org/docs/devel/sql-createtable.html To demonstrate my problem, I created a simple table called humans. I want to partition by the year of the human birth and