dbeaver: Cannot edit Postgres citext cells
System information:
- Operating system: Windows 7 pro
- DBeaver version: 22.1.2.202207091909
Connection specification:
- Database name and version: Postgresql 10.4
- Driver name: Postgresql
- Do you use tunnels or proxies (SSH, SOCKS, etc)? No
Describe the problem you’re observing:
When i try to edit cell from a View Data witch datatype Citext , DBeaver prevents the edit with a Column “ColumnName” is read-only: No corresponding table column message


DDL of table
`-- apteka.salestableapreserve definition
-- Drop table
-- DROP TABLE apteka.salestableapreserve;
CREATE TABLE apteka.salestableapreserve (
recid serial4 NOT NULL,
dataareaid public.citext NULL,
tableid int4 NULL DEFAULT 50558,
createddate timestamp NULL DEFAULT 'now'::text::timestamp without time zone,
modifieddate timestamp NULL DEFAULT 'now'::text::timestamp without time zone,
modifiedby public.citext NULL,
createdby public.citext NULL DEFAULT "current_user"(),
origrecid int4 NULL,
custaccount public.citext NOT NULL DEFAULT ''::citext,
custname public.citext NOT NULL DEFAULT ''::citext,
custphone public.citext NULL DEFAULT ''::citext,
delivery bool NOT NULL DEFAULT false,
deliverydate apteka.transdate NOT NULL DEFAULT 'now'::text::timestamp without time zone,
dis public.citext NOT NULL DEFAULT ''::citext,
disccardid apteka.disccardnum NOT NULL DEFAULT ''::citext,
finishdate apteka.transdate NOT NULL DEFAULT 'now'::text::timestamp without time zone,
newdisccard bool NOT NULL DEFAULT false,
"percent" apteka."percent" NOT NULL DEFAULT 0,
reserveby public.citext NOT NULL DEFAULT ''::citext,
reservedate apteka.transdate NOT NULL DEFAULT 'now'::text::timestamp without time zone,
reservedateperiod timestamp NOT NULL DEFAULT 'now'::text::timestamp without time zone,
reservedeliveryaddrid apteka.reservedeliveryaddrid NOT NULL DEFAULT ''::citext,
returnreason apteka.returnreasonid NOT NULL DEFAULT ''::citext,
salesreserveid public.citext NOT NULL DEFAULT ''::citext,
salesreserverefid public.citext NOT NULL DEFAULT ''::citext,
salestype public.citext NOT NULL DEFAULT ''::citext,
status public.citext NOT NULL DEFAULT ''::citext,
street public.citext NOT NULL DEFAULT ''::citext,
doorway public.citext NULL,
deliverytime apteka.reservedeliverytimeid NOT NULL DEFAULT ''::citext,
hlcard public.citext NOT NULL DEFAULT ''::citext,
kkmnum public.citext NOT NULL DEFAULT ''::citext,
inuse bool NOT NULL DEFAULT false,
built bool NOT NULL DEFAULT false,
beznal bool NOT NULL DEFAULT false,
canceled bool NOT NULL DEFAULT false,
reservetype int4 NOT NULL DEFAULT 1,
prepaid bool NOT NULL DEFAULT false,
siteid public.citext NULL,
CONSTRAINT salestableapreserve_recid PRIMARY KEY (recid),
CONSTRAINT tableid CHECK ((tableid = 50558))
);
CREATE UNIQUE INDEX salestableapreserve_salesreserveid_idx ON apteka.salestableapreserve USING btree (salesreserveid, status);
-- Table Triggers
create trigger salestableapreserve_geninsert before
insert
on
apteka.salestableapreserve for each row execute procedure salestableapreserve_numseq();
create trigger salestableapreserve_modifieddate before
update
on
apteka.salestableapreserve for each row execute procedure modifieddate();
create trigger salestableapreserve_update before
update
on
apteka.salestableapreserve for each row execute procedure salestableapreserve_update();`
About this issue
- Original URL
- State: open
- Created 2 years ago
- Reactions: 2
- Comments: 15 (5 by maintainers)
@E1izabeth
dbeaver 23.0.2 has this problem yet