18.04.2024 20:49, Alvaro Herrera wrote:
On 2024-Apr-18, Alexander Lakhin wrote:
I think the feature implementation should also provide tab completion
for SPLIT/MERGE.
I don't think that we should be imposing on feature authors or
committers the task of filling in tab-completion for whatever features
they contribute. I mean, if they want to add that, cool; but if not,
somebody else can do that, too. It's not a critical piece.
I agree, I just wanted to note the lack of the current implementation.
But now, thanks to Dagfinn, we have the tab completion too.
I have also a question regarding "ALTER TABLE ... SET ACCESS METHOD". The
current documentation says:
When applied to a partitioned table, there is no data to rewrite, but
partitions created afterwards will default to the given access method
unless overridden by a USING clause.
But MERGE/SPLIT behave differently (if one can assume that MERGE/SPLIT
create new partitions under the hood):
CREATE ACCESS METHOD heap2 TYPE TABLE HANDLER heap_tableam_handler;
CREATE TABLE t (i int, PRIMARY KEY(i)) PARTITION BY RANGE (i);
ALTER TABLE t SET ACCESS METHOD heap2;
CREATE TABLE tp_0 PARTITION OF t FOR VALUES FROM (0) TO (1);
CREATE TABLE tp_1 PARTITION OF t FOR VALUES FROM (1) TO (2);
\d t+
Partitioned table "public.t"
...
Access method: heap2
Table "public.tp_0"
...
Access method: heap2
Table "public.tp_1"
...
Access method: heap2
ALTER TABLE t MERGE PARTITIONS (tp_0, tp_1) INTO tp_0;
Partitioned table "public.t"
...
Access method: heap2
Table "public.tp_0"
...
Access method: heap
Shouldn't it be changed, what do you think?
Best regards,
Alexander