Unable to add a Postgis layer when the key attribut have an alias

[mgrizonnet]

I created 2 views VIEW _VIEW0 and VIEW _VIEW1 in PostgreSQL.

The code:

CREATE OR REPLACE VIEW _VIEW0 AS
SELECT 
t1.geom, 
t1.id
FROM table1 t1 
ORDER BY t1.id;

CREATE OR REPLACE VIEW _VIEW0 AS
SELECT 
t1.geom, 
t1.id as id_geo
FROM table1 t1 
ORDER BY t1.id;

It is the same views. The only difference is that the attribute "id" has got an "alias" (the alias is "id_geo"). The data type of id is int4 and it is a primary key (needed by QGIS to make the connection).

The first view works well but not the second. The message returned by QGIS is that the attribute "id" is not a primary key (data not unique).

But it is the same views!!!!

[pcav]

See also #1545 (now closed as it's a duplicate)

[pcav]

Just tested with:

mipi=> create view view1 as select cat, the_geom from fix where cat=2531; CREATE VIEW mipi=> create view view2 as select cat as id, the_geom from fix where cat=2531; CREATE VIEW

and QGIS can load both layers without hassle: can you please check again and report back?

[pcav]

Probably a duplicate of #1718