Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>, Alexander Lakhin <exclusion(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Date: 2026-06-15 11:07:15
Message-ID: ai_c4-v8iLA2kXFV@pryzbyj2023
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I hit an error when I tried this patch.

CREATE TABLE a (a text) PARTITION BY RANGE(a);
CREATE TABLE a1 PARTITION OF a DEFAULT;
INSERT INTO a SELECT repeat('1', 9999999);
CREATE TABLE a2 PARTITION OF a FOR VALUES FROM (2)TO(3);
ALTER TABLE a MERGE PARTITIONS (a1, a2) INTO a1;
ERROR: row is too big: size 39264, maximum size 8160

--
Justin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2026-06-15 11:15:38 Re: Proposal: Conflict log history table for Logical Replication
Previous Message Dilip Kumar 2026-06-15 10:54:24 Re: Proposal: Conflict log history table for Logical Replication