[Qgis-developer] qgis freezes when opening attribute table of a postgis layer without key value

Régis Haubourg regis.haubourg at eau-adour-garonne.fr
Fri May 23 08:15:08 PDT 2014

Hi again, 
my problem is unsolved. I eliminated either additionnal geometry column or
oid/ pk / select at id causes. 

for a very simple postgis table, no way to open the attribute table, Qgis
freezes and transaction needs to be aborted on postgres side. 

Any idea? Am I alone?

see table definition : 
-- Table: dce.masse_eau_anomalie

-- DROP TABLE dce.masse_eau_anomalie;

CREATE TABLE dce.masse_eau_anomalie
  id_anomalie integer NOT NULL DEFAULT
  eu_cd character varying(24) NOT NULL,
  version_dce character varying(10) NOT NULL,
  description_anomalie text,
  date_signalement date NOT NULL,
  operateur character varying(15) NOT NULL,
  date_correctif date,
  statut character varying(20),
  geom_point geometry, -- localisation de l'anomalie
  CONSTRAINT pk_masse_eau_anomalie PRIMARY KEY (id_anomalie),
  CONSTRAINT enforce_dims_geom_point CHECK (st_ndims(geom_point) = 2),
  CONSTRAINT enforce_geotype_geom_point CHECK (geometrytype(geom_point) =
'POINT'::text OR geom_point IS NULL),
  CONSTRAINT enforce_srid_geom_point CHECK (st_srid(geom_point) = 2154)
ALTER TABLE dce.masse_eau_anomalie
  OWNER TO postgres;
GRANT ALL ON TABLE dce.masse_eau_anomalie TO postgres;
COMMENT ON TABLE dce.masse_eau_anomalie
  IS 'stocke les anomalies constatées pour les futures mises à jour';
COMMENT ON COLUMN dce.masse_eau_anomalie.geom_point IS 'localisation de

View this message in context: http://osgeo-org.1560.x6.nabble.com/qgis-freezes-when-opening-attribute-table-of-a-postgis-layer-without-key-value-tp5141587p5142176.html
Sent from the Quantum GIS - Developer mailing list archive at Nabble.com.

More information about the Qgis-developer mailing list