[Qgis-developer] Problem with Postgis 2.0 Views and picking (info-tool)

[Denis Rouzaud]

Hi Andreas,

I have similar problems, but with Postgis 1.5.
I posted last week on qgis and postgis users: 
http://old.nabble.com/MultiPoint-to-CircularString-to-LineString-td33132890.html

In my case, I noticed thaht when building a geometry, you have to 
enforce the SRID in it, with EWKT for example. If you don't want to, you 
have to feed a -1 for the SRID in the geometry_columns.

If you do not do this (i.e. have a SRID in geometry_columns and nothing 
in the view), there is no error in postgis, but you have a problem in 
QGIS. I have experienced the same error:

Query: CLOSE qgisf0 returned 7 [ERROR:  current transaction is aborted,
commands ignored until end of transaction block
]

Hope it helps a bit,

Denis

On 01/18/2012 12:07 AM, Andreas Neumann wrote:
> Hi,
>
> I recently experimented again with Postgis 2.0 again. I noticed while
> loading the Views works fine, that I cannot pick an object with the info
> tools.
>
> It works fine with regular tables, but fails for views.
>
> Here is the error message I get in the log:
> -----------------------
> Fetching from cursor qgisf0 failed
> Database error: ERROR:  Operation on mixed SRID geometries
>
> Query: CLOSE qgisf0 returned 7 [ERROR:  current transaction is aborted,
> commands ignored until end of transaction block
> ]
>
> 1 cursor states lost.
> SQL: CLOSE qgisf0
> Result: 7 (ERROR:  current transaction is aborted, commands ignored
> until end of transaction block
> )
>
> -----------------
>
> The error message about the mixed geometries is strange, since the view
> and the project have the same SRID.
>
> Any idea what could be wrong here? Currently I only have a Postgis 2.0
> database available, so I can't test with Postgis 1.5 at the same time.
> Maybe with a virtual machine ...
>
> Andreas
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/qgis-developer/attachments/20120118/bc85e38e/attachment.html