Обсуждение: pgAdmin4 can't re-attach some previously detached partition

Поиск
Список
Период
Сортировка

pgAdmin4 can't re-attach some previously detached partition

От
Petr Fedorov
Дата:

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



Вложения

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

От
Akshay Joshi
Дата:
Hi Petr

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

On Thu, Apr 11, 2019 at 5:01 PM Petr Fedorov <petr.fedorov@phystech.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
Вложения