>>>> I've been using Qgis in the 1.0 previews without problems. Now, with
>>>> the 1.0.1 release via the online installer (on WinXP), my PostGIS
>>>> layers do not load anymore. Nothing in the database changed, so this
>>>> is probably a QGis issue.
>>>
>>> No issues here (but we have OIDs).
>>> pc
>
>> Hi Paolo and list,
>>
>> Unfortunately that does not make it work over here :-) Even with OIDs
>> I get an error message about the query.
>>
>> Should I send this to the dev mailing list, maybe? Surely there has to
>> be someone who knows more about what's going on behind the QGis scene
>> here.
>>
>> Kind regards,
>> arnout
>
> I have no problems loading PostGIS data with QGIS 1.0.1
> installed on XP with OSGeo-Installer (no oids). Can you
> display _any_ PostGIS-layer? If not maybe it is a connection
> problem? Can you make a select from the same machine on the
> particular table using the same DB access (username, passsword)?
>
> regards
>
> Bernhard
It gives errors on every PostGIS layer I try, also in other databases on this
Postgres server. I did some logging on the server side, and the queries sent by
QGis actually work if I try them directly on the database. So in any case, they
are valid queries.
BUT: I systematically see this query last:
select
pg_class.relname,pg_namespace.nspname,pg_attribute.attname,pg_class.relkind
from pg_attribute, pg_class, pg_namespace
where pg_namespace.oid = pg_class.relnamespace
and pg_attribute.attrelid = pg_class.oid
and (pg_attribute.atttypid = regtype('geometry')
or pg_attribute.atttypid IN (select oid FROM pg_type WHERE
typbasetype=regtype('geometry')))
and has_schema_privilege(pg_namespace.nspname,'usage')
and
has_table_privilege('"'||pg_namespace.nspname||'"."'||pg_class.relname||'"','select')
and not exists (select * from geometry_columns WHERE
pg_namespace.nspname=f_table_schema AND pg_class.relname=f_table_name)
and pg_class.relkind in ('v', 'r')
It's a valid query, but it does not return any result! Now that might be a big
clue, so I'm looking further into this...
Thanks a lot for your suggestions, feel free to share any further ideas!
arnout
---
This e-mail, any attachments and the information it contains are confidential
and meant only for the use of the addressee(s) only. Access to this e-mail by
anyone other than the addressee(s) is unauthorized. If you are not the
intended addressee (or responsible for delivery of the message to such person),
you may not use, copy, distribute or deliver to anyone this message (or any
part of its contents) or take any action in reliance on it. In such case, you
should destroy this message and notify the sender immediately. If you have
received this e-mail in error, please notify us immediately by e-mail or
telephone and delete the e-mail from any computer.
All reasonable precautions have been taken to ensure no viruses are present in
this e-mail and its attachments. As our company cannot accept responsibility
for any loss or damage arising from the use of this e-mail or attachments we
recommend that you subject these to your virus checking procedures prior to use.
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
