If I have a PostGIS database that has a table with an integer column that has a sequence that will normally autofill it, how do I get QGIS to not make me fill out that field (and not try to put
NULL in it either)?
Everything I seem to do seems to make me either manually manage coming up with new
"ID"s or try to put
NULL in the column and then fails because the
"ID" column is defined as being not
What do I need to do in QGIS to get it to not specific a value for that column and just let the database (PostGIS) fill it in?
This is with QGIS version 3.8.
This is the definition of one of the tables I'm having trouble with:
CREATE TABLE public.utility_pole ( id integer NOT NULL, pole_owner text, pole_owner_primary_label text, latlong public.geometry(Point,4326) NOT NULL ); ALTER TABLE public.utility_pole OWNER TO postgres; ALTER TABLE public.utility_pole ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY ( SEQUENCE NAME public.utility_pole_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); ALTER TABLE ONLY public.utility_pole ADD CONSTRAINT utility_pole_id_pk PRIMARY KEY (id);