Re: pgAdmin4 can't re-attach some previously detached partition

Hi Petr

Please log an issue https://redmine.postgresql.org.

On Thu, Apr 11, 2019 at 5:01 PM Petr Fedorov <petr(dot)fedorov(at)phystech(dot)edu>
wrote:

> 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
>
>
>
>

--
*Thanks & Regards*
*Akshay Joshi*

*Sr. Software Architect*
*EnterpriseDB Software India Private Limited*
*Mobile: +91 976-788-8246*