[Qgis-user] Problems loading postgis layers

[Andreas Neumann]

 yes, seems like a more serious problem in Postgis.

 Perhaps consult the Postgis mailinglist about it?

 Did you recently run an upgrade on this database? Or other changes of 
 the underlying libraries, such as geos?

 Andreas

 On Wed, 17 Aug 2011 14:35:49 +0200, Andreas Forø Tollefsen wrote:
> Hi Andreas,
>
> I tried using pgAdmin to access a file.
> i.e. 
> query: SELECT * FROM priogrid;
>
> ERROR:  Unknown geometry type: 0 - Unknown
>
> ********** Error **********
>
> ERROR: Unknown geometry type: 0 - Unknown
> SQL state: XX000
>
> I also tried to do this on the computer running the server. From
> terminal.
> psql priogrid 
> and then
> SELECT * FROM priogrid;
>
> Same error: ERROR: Unknown geometry type: 0 - Unknown.
>
> Maybe i have corrupted my whole database. I can access all the table
> columns except for the geometrical ones.
>
> Any ideas?
>
> 2011/8/17 Andreas Neumann
>
>> Hi,
>>
>> Did you double check that the permissions are ok and that all the
>> Postgis connection parameters are ok (or perhaps different from
>> version 1.6)?
>>
>> Can you access the Postgis tables with pgAdmin3 from the same
>> machine using the same credentials?
>>
>> It could be a number of issues - permissions or wrong connection
>> settings are quite likely.
>>
>> Andreas
>>
>> On Wed, 17 Aug 2011 13:54:58 +0200, Andreas Forø Tollefsen wrote:
>>
>>> Hi all.
>>>
>>> I recently upgraded my QGIS to 1.7. Previously using QGIS 1.6. 
>>> Now i cant load postgis layers from the same server as i used
>>> previously.
>>> The problem occurs when i select a layer in the postgis
>>> connection and
>>> try to add this.
>>>
>>> For instance when trying to add the cshapes dataset i get this
>>> error:
>>>
>>> Unable to access the "public"."cshapes" relation.
>>>
>>> The error message from the database was:
>>>
>>> ERROR: Unknown geometry type: 65536 - Unknown
>>>
>>> .
>>>
>>> SQL: select * from "public"."cshapes" limit 1
>>>
>>> Then i get a 'Invalid Layer' box which tells me that the cshapes
>>> layer
>>> is invalid and cannot be added to QGIS.
>>>
>>>  This happens with all of the 400 tables i have stored on my
>>> PostGIS
>>> server.
>>>
>>>  Any ideas why this happens?
>>>
>>>  Thanks in advance.
>>>
>>> Andreas
>>
>> --
>> --
>> Andreas Neumann
>> Böschacherstrasse 10A
>> 8624 Grüt (Gossau ZH)
>> Switzerland
>
>
>
> Links:
> ------
> [1] mailto:a.neumann at carto.net

-- 
 --
 Andreas Neumann
 Böschacherstrasse 10A
 8624 Grüt (Gossau ZH)
 Switzerland