MIME-Version: 1.0
In-Reply-To: <LV8P220MB09555DBF54A6F74131D92D88F7BB2@LV8P220MB0955.NAMP220.PROD.OUTLOOK.COM>
References: <LV8P220MB09555DBF54A6F74131D92D88F7BB2@LV8P220MB0955.NAMP220.PROD.OUTLOOK.COM>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 21 Apr 2025 22:02:21 -0700
Message-ID: <CAKFQuwbHvjjrYSKV2JioP-R0HmTtsztMYv_fCV9odyHvMhTqow@mail.gmail.com>
Subject: Re: sequence on daily log partitioned table
To: senor <frio_cervesa@hotmail.com>
Cc: "pgsql-general@lists" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c9afe8063356e3e0"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbHvjjrYSKV2JioP-R0HmTtsztMYv_fCV9odyHvMhTqow%40mail.gmail.com>
Precedence: bulk

--000000000000c9afe8063356e3e0
Content-Type: text/plain; charset="UTF-8"

On Monday, April 21, 2025, senor <frio_cervesa@hotmail.com> wrote:
>
> I'm mainly interested in understanding how this works or why it can't
>

Partition routing happens on fully-formed tuples.  They thus must be formed
initially using only context, like defaults, attached to the partitioned
table.

You can do what you want if you directly insert into the individual
partitions, using the partitioned table as a read-only interface.

It looks like this:

https://dbfiddle.uk/Xc3cUHSO

David J.

--000000000000c9afe8063356e3e0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Monday, April 21, 2025, senor &lt;<a href=3D"mailto:frio_cervesa@hotmail=
.com">frio_cervesa@hotmail.com</a>&gt; wrote:<blockquote class=3D"gmail_quo=
te" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"=
><div dir=3D"ltr">
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
I&#39;m mainly interested in understanding how this works or why it can&#39=
;t</div></div></blockquote><div><br></div><div>Partition routing happens on=
 fully-formed tuples.=C2=A0 They thus must be formed initially using only c=
ontext, like defaults, attached to the partitioned table.</div><div><br></d=
iv><div>You can do what you want if you directly insert into the individual=
 partitions, using the partitioned table as a read-only interface.</div><di=
v><br></div><div>It looks like this:</div><div><br></div><div><a href=3D"ht=
tps://dbfiddle.uk/Xc3cUHSO">https://dbfiddle.uk/Xc3cUHSO</a><br></div><div>=
<br></div><div>David J.</div><div><br></div>

--000000000000c9afe8063356e3e0--