Re: Editing integer array cell clears data

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.

---

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