From: senor <frio_cervesa@hotmail.com>
To: "pgsql-general@lists" <pgsql-general@lists.postgresql.org>
Subject: sequence on daily log partitioned table
Thread-Topic: sequence on daily log partitioned table
Thread-Index: AQHbsydp9FePlFlSokOGB4va7Gq0Sg==
Date: Tue, 22 Apr 2025 04:26:10 +0000
Message-ID:
 <LV8P220MB09555DBF54A6F74131D92D88F7BB2@LV8P220MB0955.NAMP220.PROD.OUTLOOK.COM>
Accept-Language: en-US
Content-Language: en-US
msip_labels:
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: LV8P220MB0955:EE_|PH0P220MB0572:EE_
x-ms-office365-filtering-correlation-id: e4f0eaa1-c047-4c60-c31e-08dd8155cf2f
x-microsoft-antispam:
 BCL:0;ARA:14566002|19110799003|8060799006|15030799003|461199028|8062599003|15080799006|7092599003|440099028|3412199025|102099032;
x-microsoft-antispam-message-info:
 =?iso-8859-1?Q?gOB8p+0iRMIZPLOJw1FADjfp12n7LeCU+kw0dLYRdCSxeYcY7iriRwdBRB?=
 =?iso-8859-1?Q?5CnaFmvypcDa8s1Ux6VanwK4s7DKjkXsChUSRzJj8B4yJbF+veerP4jGWZ?=
 =?iso-8859-1?Q?HtAZ+c8XSroMHhFTUmf+Z60leEkqhunpGDiVdK80FBpklzWCjeItN0bH4X?=
 =?iso-8859-1?Q?LCczvvcRgcByUul5jfvxFhbNnmrt3gQpNGkRR8Q2dRUZDKiD42YaTrb56H?=
 =?iso-8859-1?Q?yaCK4Ry4/lX0kEhMaZAFdeZHl1uR0IKJ4JB+IIy/HJPktnp/s8PF/MWJAy?=
 =?iso-8859-1?Q?LpTz2yPmcrrd9++6qZqoS3PY6qiCRVfNa2XgoBSzj1H/lptd4CVg/jX8LZ?=
 =?iso-8859-1?Q?wXzV66gpUwOH/qfNgd2nufoTDEypXLrIRUNiN7y03gOXqyHmpkWFI2GqPD?=
 =?iso-8859-1?Q?o/VSfFs9SIqpNA1WOZ1pWCLsluH0iFHj4FISDIu0H9wSuwEnoscSvvKtJ+?=
 =?iso-8859-1?Q?K8WOdDZSQEKUFWznwQhnHUEqJCDKzxMLMjsEV2izxVohlF1VrZlNWj9aj4?=
 =?iso-8859-1?Q?3wA4kFkSo4TTc7tGFDZujFGJ6qQXnWtmLgHwyq1W86ubKPB1xRy6OIS+Oe?=
 =?iso-8859-1?Q?iicjZL34y/4ITKK9rE8CB9XkvxoSnik7ME3q2UmHKyC9QYm5PSxHx3cYDp?=
 =?iso-8859-1?Q?wxQ+SM8l02UzUXAWmMaXc1/+PrSimV+/QY47VzkNjWgD0oLXoS5wSnSHfS?=
 =?iso-8859-1?Q?W50WKPN+YeHMbMxk+oaNz0kHGZAEMuk1ZFmb56Y+UCJowev0T7QH9XgGiB?=
 =?iso-8859-1?Q?nJphV8c3QGbnVUOsD2vgN4bQAURQCrbniWGKbX278DXc1rO/4njI/o64Lq?=
 =?iso-8859-1?Q?hNhCTlRZEkN3AoM/N3sfjReQRrj4NhauLFJ5qpb+jDs7U4LMWlDKAEXtFW?=
 =?iso-8859-1?Q?ZHw9enWp5JHl/tDhG6A2ffwJRsigA3KRBiryOc/mPRlWXf2aI9IY1/P9PI?=
 =?iso-8859-1?Q?vA1r/KP64nvaLXiQ4i6x9bbCbYn1gR5mE4iCzq6x/c8Q2MpalmMxxmtibb?=
 =?iso-8859-1?Q?Cklu5FMmEe3st+ukcpdmfBw4frPp9I47by0+HuTw9gwU8nKub5sVYa1Xto?=
 =?iso-8859-1?Q?lBUFbD6EgCNty2v0271iYieZDZwzIxEdoXp4CvjmPHCei+IrnVXFbAFRxu?=
 =?iso-8859-1?Q?L5P71f4CHgJmMLYKAypkpdlomfoXhw/aIetzMEQY/BNhMvQhUsYl/bJ9B5?=
 =?iso-8859-1?Q?xFn2PwZCdQlJ5Q=3D=3D?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-1?Q?AOLl31tV64RpHfK3Z7Nm5OIjiLX+84J6YYUPCdjio0Qdk7jVmi7ayhxgM1?=
 =?iso-8859-1?Q?W7T+1STlvaXgPYj0Nvk6KGd6mryg7h6RxywDv3E9R+qYb/WESwSNoqCHPM?=
 =?iso-8859-1?Q?ejb8hpz5prcoI/B+vLwb/BW4R6bje4CQATzcJUnKM0AG4+IqR9OBTVFbZl?=
 =?iso-8859-1?Q?PoMDsFHGBX2xmYQziUv933r9Zfaf5npR3nFmFyrDs0WySpBGZK1ktQ4EUR?=
 =?iso-8859-1?Q?pZ3BtkMxczzz2odNXYupRnWR+fqfyIMkt8JP/Z4FvI6iEQ5UEviTRn14Fl?=
 =?iso-8859-1?Q?D0JcVTcyNmfIAc2pQZUvHb49uRa2sgsun/lagVpERCg3FOImdXynTNO3Tc?=
 =?iso-8859-1?Q?8e4JgqvQ1+BJ/F6NIjhTTWZvsE1oFLhZi4OIamYdu3DQA7OX5DkY7EddTK?=
 =?iso-8859-1?Q?OCAbIrew3fCRBgV1hDH6YUsqskSFqpNiAjGcj8sgwZS7zqgXTMkfDuEPBP?=
 =?iso-8859-1?Q?0ewV59706qeujda/9M9XaqQwQi7IiL0UNqsunsimWVRJ7mgrNeuzzsrR0z?=
 =?iso-8859-1?Q?anxjEZhf8aq3z8Lcd5uLcPdWh/UHB1nhQsE35OrZyfPcScLSchXoJOBPCX?=
 =?iso-8859-1?Q?P/aoe+MKlfSWGX3wGWBHUc2ZR3iWXctOoI2tuxorLKEyTL9utAi/9zya6R?=
 =?iso-8859-1?Q?iNyn5Di9eGVQRHhooxpoMuiElXGUNI+kWkl3enF02cVX9AclqwnrjDcnW7?=
 =?iso-8859-1?Q?mAAurDLy93HV5qs/nKMmdIGUe6l7K84vkPUXEqQEa9kKAgJLPUbARW7UKi?=
 =?iso-8859-1?Q?7e7hZorgbSeAfgqJlJP+vmpVb7mSoGkNkafLchNNcV/myEaFQ8PHhJhXQt?=
 =?iso-8859-1?Q?P8ti4bTm9H3Y9k5No12dY00rqMvFTXKGGncPk8c/cPr8V+2Sq+ZWkyXhvQ?=
 =?iso-8859-1?Q?n/WpKCkRYChke8oRlPfa/NmmGzPaS7hrBvfSLciqyXGTCxrqf/WXOKbwlq?=
 =?iso-8859-1?Q?M28hJZqKoZKrUqe9v4ofljT883Dx/tZzDV3x4OqDDbZk3Aeg26W/7fFC+6?=
 =?iso-8859-1?Q?ePsxZX4TVsPvlUAY55wqWrTdN9WH+qCZeL0bvhbGQHd4RWf/FMoW4fBiA1?=
 =?iso-8859-1?Q?WMGIheGTHXDdO2sMKlZswT5n8llyy+aAL9xk2iw1U6nUQPqu9LWbuQQbdw?=
 =?iso-8859-1?Q?4bqpWB/rVhofjFUgkK0vsKSJ1gPAAnsFUQ9P7RcB67U9mfibIp418eY0O1?=
 =?iso-8859-1?Q?oVIEmHoEBQ2AeUHaKC/GQGioVfumanw8NPv+gH64P5I1wG5hDf/jWfhxl0?=
 =?iso-8859-1?Q?8xxyNlQB4nxnvwfNM+DFHhzIBDJoBt2JEBEgCzBXg=3D?=
Content-Type: multipart/alternative;
	boundary="_000_LV8P220MB09555DBF54A6F74131D92D88F7BB2LV8P220MB0955NAMP_"
MIME-Version: 1.0
X-OriginatorOrg: sct-15-20-7719-20-msonline-outlook-17562.templateTenant
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: LV8P220MB0955.NAMP220.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: e4f0eaa1-c047-4c60-c31e-08dd8155cf2f
X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Apr 2025 04:26:10.4232
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PH0P220MB0572
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/LV8P220MB09555DBF54A6F74131D92D88F7BB2%40LV8P220MB0955.NAMP220.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_LV8P220MB09555DBF54A6F74131D92D88F7BB2LV8P220MB0955NAMP_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All,

I'm mainly interested in understanding how this works or why it can't, as o=
pposed to just solving the problem. AI just told me this can't be done with=
out a trigger but I'd like to confirm in case maybe I just asked the wrong =
question.

I want to have a partitioned log table receiving input from sensor equipmen=
t. The partitions would cover some time range like an hour or day. In all c=
ases I want an ID column to default to a nextval from a sequence but starti=
ng over for each day. If I set the default on the partitioned table, I woul=
d need to alter it at midnight - not optimal. A default set on the partitio=
n hasn't worked and I'm not sure why this is a problem.

I've only ever used simplistic partitioning but this doesn't seem like an u=
nusual need. I'm looking for the underlying strategy that prevents use of t=
he sequence configured on the partition. A reference to something describin=
g the decision flow would be fantastic.

I've been experimenting on version 13 out of convenience but if a newer ver=
sion has relevant changes, I'm interested. I'm not interested in the discus=
sions over whether the data volume is enough to justify partitioning.

Thanks in advance,
Senor

--_000_LV8P220MB09555DBF54A6F74131D92D88F7BB2LV8P220MB0955NAMP_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi All,</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I'm mainly interested in understanding how this works or why it can't, as o=
pposed to just solving the problem. AI just told me this can't be done with=
out a trigger but I'd like to confirm in case maybe I just asked the wrong =
question.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I want to have a partitioned log table receiving input from sensor equipmen=
t. The partitions would cover some time range like an hour or day. In all c=
ases I want an ID column to default to a nextval from a sequence but starti=
ng over for each day. If I set the
 default on the partitioned table, I would need to alter it at midnight - n=
ot optimal. A default set on the partition hasn't worked and I'm not sure w=
hy this is a problem.&nbsp;</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I've only ever used simplistic partitioning but this doesn't seem like an u=
nusual need. I'm looking for the underlying strategy that prevents use of t=
he sequence configured on the partition. A reference to something describin=
g the decision flow would be fantastic.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"text-align: left; text-indent: 0px; =
margin: 0px; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; =
color: rgb(0, 0, 0);">
I've been experimenting on version 13 out of convenience but if a newer ver=
sion has relevant changes, I'm interested. I'm not interested in the discus=
sions over whether the data volume is enough to justify partitioning.&nbsp;=
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks in advance,</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Senor</div>
</body>
</html>

--_000_LV8P220MB09555DBF54A6F74131D92D88F7BB2LV8P220MB0955NAMP_--