[Qgis-user] PostGIS layers invalid in 1.0.1

[Standaert Arnout]

>>>> 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.