pgAdmin4 can't re-attach some previously detached partition - Mailing list pgadmin-support

From Petr Fedorov
Subject pgAdmin4 can't re-attach some previously detached partition
Date
Msg-id 6a7dbbd1-e9ed-cf92-8747-bba083b251e4@phystech.edu
Whole thread Raw
Responses Re: pgAdmin4 can't re-attach some previously detached partition  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
List 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



Attachment

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: pgAdmin 4 v4.5 released
Next
From: Jürgen Spatz
Date:
Subject: Group tables in PG-Admin