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.vashi@enterprisedb.com> wrote:

On Tue, Jan 15, 2019 at 4:44 PM Janus <janus.e@gmail.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.