I am wondering if anyone has any ideas of how I can recover a project that is stored in a PostGIS database. When I try to open the project it loads indefinitely (I shut it off after a few hours) for a project that used to load in a minute or so. There is no network activity to suggest that the loading is due to data transfer, etc.. The individual layers load from the database without any problem, so I don't think it is a question of the connection. I tried the following query SELECT "name", convert_from(decode(encode(qgis_projects.content, 'escape'),'escape'), 'Latin1') AS project_latin1, encode(qgis_projects.content, 'escape') AS project_hex FROM qgis_projects WHERE "name" = 'my_project' but with Latin1 and UTF8 I get an error stating ERROR: invalid byte sequence for encoding "UTF8": 0x00 SQL state: 22021 -Thayer
_______________________________________________ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
