pgAdmin4 can't re-attach some previously detached partition

From: Petr Fedorov <petr(dot)fedorov(at)phystech(dot)edu>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin4 can't re-attach some previously detached partition
Date: 2019-04-11 11:31:19
Message-ID: 6a7dbbd1-e9ed-cf92-8747-bba083b251e4@phystech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,

I recognized that for some reasons pgAdmin4 does not allow to re-attach
some of the previously detached partitions:

Here is the test script to reproduce:

create table test (id integer, col1 integer, col2 integer) partition by
list (id);

create table test1 partition of test for values in (1);

alter table test drop column col2;  

create table test2 partition of test for values in (2);

alter table test detach partition test1;

alter table test detach partition test2;

pgAdmin4 allows to attach back test1 but not test2!  Both tables can be
re-attached with alter table command without any problems.

I'm on pgAdmin 4.2 on Centos7 and Fedora 29

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Jürgen Spatz 2019-04-16 19:01:44 Group tables in PG-Admin
Previous Message Dave Page 2019-04-11 11:17:39 Re: pgAdmin 4 v4.5 released