QGIS » QGIS Application

Whenever the type of a primary key for a PostgreSQL table is defined as BigInt, the ‘Feature Attributes’ pop-up window is not displayed in case large numbers are inserted.

--element with BIGINT as PKEY (no popup)
DROP TABLE IF EXISTS ele1;
CREATE TABLE ele1(ipid bigint NOT NULL, geom geometry(LineString,32628), CONSTRAINT ele1_pkey PRIMARY KEY (ipid)) WITH (OIDS=FALSE);
CREATE INDEX spatial_index_ele1 ON ele1 USING gist (geom);

INSERT INTO ele1(ipid,geom) VALUES (1, st_geomfromewkt('SRID=32628;LINESTRING(0 0,1 0)'));
INSERT INTO ele1(ipid,geom) VALUES (111111111111111111, st_geomfromewkt('SRID=32628;LINESTRING(0 1,1 1)')); -- NO POPUP

--element without PKEY
DROP TABLE IF EXISTS ele2;
CREATE TABLE ele2( ipid bigint NOT NULL, geom geometry(LineString,32628)) WITH ( OIDS=FALSE );
CREATE INDEX spatial_index_ele2 ON ele2 USING gist (geom);

INSERT INTO ele2(ipid,geom) VALUES (2, st_geomfromewkt('SRID=32628;LINESTRING(0 2,1 2)'));
INSERT INTO ele2(ipid,geom) VALUES (222222222222222222, st_geomfromewkt('SRID=32628;LINESTRING(0 3,1 3)'));

--element with PKEY as text
DROP TABLE IF EXISTS ele3;
CREATE TABLE ele3 ( ipid text NOT NULL, geom geometry(LineString,32628), CONSTRAINT ele3_pkey PRIMARY KEY (ipid)) WITH ( OIDS=FALSE);
CREATE INDEX spatial_index_ele3 ON ele3 USING gist (geom); 

INSERT INTO ele3(ipid,geom) VALUES ('3', st_geomfromewkt('SRID=32628;LINESTRING(0 4,1 4)'));
INSERT INTO ele3(ipid,geom) VALUES ('333333333333333333', st_geomfromewkt('SRID=32628;LINESTRING(0 5,1 5)'));11111111', st_geomfromewkt('SRID=32628;LINESTRING(0 0,1 0)'));

Please check document attached for more information.