Re: Editing integer array cell clears data

On Tue, Jan 15, 2019 at 7:23 PM Janus <janus(dot)e(at)gmail(dot)com> wrote:

> Khushboo, that is exatcly what I do, but the content of the cell is
> cleared/emptied when editing a cell containing integer array data. The
> click & edit method works fine for other data types I have tried to edit.
>
> I have a table defined as below. The answer_values column contains {1,2},
> but when editing this cell, no popup is displayed as when editing
> answer_texts values. Instead, the edit view for answer_values is looking
> like the edit view for the stratification_id column, but with the cell
> content removed. When focus is moved to another cell, and no editing had
> occured, the display value of the answer_values is [null], i.e., the cell
> is empty.
>
> Now I understood correctly, you can go ahead and log this issue @
https://redmine.postgresql.org/projects/pgadmin4/

> ---
>
> CREATE TABLE public.stratification
> (
> stratification_id integer NOT NULL,
> question_text character varying COLLATE pg_catalog."default" NOT NULL,
> answer_texts character varying[] COLLATE pg_catalog."default" NOT NULL,
> answer_values integer[] NOT NULL,
> study integer NOT NULL,
> CONSTRAINT stratification_id_pk PRIMARY KEY (stratification_id),
> CONSTRAINT study_fk FOREIGN KEY (study)
> REFERENCES public.study (study_id) MATCH SIMPLE
> ON UPDATE NO ACTION
> ON DELETE NO ACTION
> )
> WITH (
> OIDS = FALSE
> )
> TABLESPACE pg_default;
>
> ALTER TABLE public.stratification
> OWNER to postgres;
>
> On Tue, 15 Jan 2019 at 12:22, Khushboo Vashi <
> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>
>>
>>
>> On Tue, Jan 15, 2019 at 4:44 PM Janus <janus(dot)e(at)gmail(dot)com> wrote:
>>
>>> Windows 10, pgAdmin 4.1. select version() = PostgreSQL 11.1 on
>>> x86_64-pc-mingw64, compiled by gcc.exe (Rev5, Built by MSYS2 project)
>>> 4.9.2, 64-bit
>>>
>>> I have a table with a column defined with integer[] data type. When
>>> attempting to edit this using the pgAdmin GUI (double-click cell in View
>>> Data), the content of the cell (e.g {1,2}) is cleared. When exiting the
>>> cell, the empty cell is now rendered with the [null] text.
>>>
>> You can edit the data by clicking on the cell itself. After editing
>> please remove the focus from that cell (by clicking outside of the grid)
>> and then save the changes. I hope this will be helpful for you.
>>
>>> I was expecting to be able to edit the data directly like when double
>>> clicking a cell defined with character varying[] data type.
>>>
>>