Automatic key generation on insert in query tool

[Covarians]

When we use the view/edit data on a table with a primary key, in version 8.13 it was possible to insert a new row with the 'Add row' button and when saving pgadmin would generate the key automatically for that new row.

On version 8.14 this same action leads to an error.

I had to reverse down to 8.13 to be able to use PGAdmin

[adityatoshniwal]

@Covarians What is the error? Please share screenshots/screen recording.

[Covarians]

cannot insert a non-DEFAULT value into column "station_id"
Column "station_id" is an identity column defined as GENERATED ALWAYS.
HINT: Use OVERRIDING SYSTEM VALUE to override.

[adityatoshniwal]

cannot insert a non-DEFAULT value into column "station_id" Column "station_id" is an identity column defined as GENERATED ALWAYS. HINT: Use OVERRIDING SYSTEM VALUE to override.

Please share the table DDL.

[Covarians]

-- Table:station

-- DROP TABLE IF EXISTS station;

CREATE TABLE IF NOT EXISTS station
(
station_id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
serial_nr smallint NOT NULL,
config jsonb,
description text COLLATE pg_catalog."default",
name_short character(6)[] COLLATE pg_catalog."default",
config_name name COLLATE pg_catalog."C",
CONSTRAINT station_pkey PRIMARY KEY (station_id)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS station
OWNER to postgres;

[adityatoshniwal]

I'm able to reproduce this, looks like a special case.