pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
Cc: Matti Linnanvuori <matti.linnanvuori@portalify.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
Date: Mon, 22 May 2023 07:17:53 -0600
Message-ID: <9558F0D3-4B5B-4CE2-A27F-156149E75916@elevated-dev.com> (raw)
In-Reply-To: <VI1PR10MB7671D817E765A2ADFA174CAD8D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>
References: <VI1PR10MB76711B1B17D38E3CFF4E73008D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>
	<VI1PR10MB7671180739AB51DF1455A1A48D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>
	<404AADDB-83F9-4A4A-B6D7-E736C278EFDA@portalify.com>
	<VI1PR10MB7671D817E765A2ADFA174CAD8D439@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM>

> On May 22, 2023, at 1:02 AM, Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com> wrote:
> 
> Hello!
> The following limitations apply to partitioned tables:
>     • 
> To create a unique or primary key constraint on a partitioned table, the partition keys must not include any expressions or function calls and the constraint's columns must include all of the partition key columns.

Your choices:

1) Deal with reality: have placedon as part of the primary key
2) don't partition on it, index placedon
3) don't partition on it, index (brandid, playerid, placedon)






view thread (18+ messages)  latest in thread

Message-ID: <9558F0D3-4B5B-4CE2-A27F-156149E75916@elevated-dev.com>
Permalink:  ../9558F0D3-4B5B-4CE2-A27F-156149E75916@elevated-dev.com/
Also on:    postgresql.org/message-id/9558F0D3-4B5B-4CE2-A27F-156149E75916@elevated-dev.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, phani.somayajula@pragmaticplay.com, matti.linnanvuori@portalify.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Partition By Range Without PrimaryKey : Postgresql Version 12.8 on AWS RDS
  In-Reply-To: <9558F0D3-4B5B-4CE2-A27F-156149E75916@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox