[Qgis-developer] pg layer not loaded

[Paolo Cavallini]

Il 11/01/2012 16:51, Andreas Neumann ha scritto:
> Hi Paolo,
>
> Are they views or real tables?
>
> I had problems with views that weren't registered in the geometry_columns table, but
> Jürgens recent fix from yesterday evening fixed these issues.
>
> With my data everything looks good now with the most recent builds.

Tested again with current trunk. I think this is the issue:

The table has no column suitable for use as a key. Quantum GIS requires a primary 
key, a PostgreSQL oid column or a ctid for tables.

Query: DECLARE qgisf4 BINARY CURSOR FOR SELECT asbinary("st_union",'NDR'),oid FROM 
"public"."buffer_union2" WHERE "st_union" && setsrid('BOX3D(712012.2051045278785750 
4663976.2016702126711607, 2613218.1114688431844115 
4981594.7239419762045145)'::box3d,3003) returned 7 [ERROR:  column "oid" does not exist
RIGA 1: ...NARY CURSOR FOR SELECT asbinary("st_union",'NDR'),oid FROM "...
                                                              ^
]1 cursor states lost.
SQL: DECLARE qgisf4 BINARY CURSOR FOR SELECT asbinary("st_union",'NDR'),oid FROM 
"public"."buffer_union2" WHERE "st_union" && setsrid('BOX3D(712012.2051045278785750 
4663976.2016702126711607, 2613218.1114688431844115 
4981594.7239419762045145)'::box3d,3003)
Result: 7 (ERROR:  column "oid" does not exist
RIGA 1: ...NARY CURSOR FOR SELECT asbinary("st_union",'NDR'),oid FROM "...
                                                              ^
)
-- 
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc