Bug report #3329
Error for postgres's provider when table(statement SELECT ) is outside public's schema
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Low | ||
| Assignee: |  Giuseppe Sucameli | ||
| Category: | Data Provider | ||
| Affected QGIS version: | Regression?: | No | |
| Operating System: | All | Easy fix?: | No |
| Pull Request or Patch supplied: | Resolution: | fixed | |
| Crashes QGIS or corrupts data: | Copied to github as #: | 13389 |
Description
When used layers outside public's schema has problem where layer is defined with statement SQL.
The problem is message of error, but, the layer is created correct.
Menssage Error:
SQL: declare oidcursor binary cursor for select regclass...
The example of layer:
dbname='postgis' host=localhost port=5432 user='postgres' key='gid' table="(select l.id AS gid, l.the_geom AS the_geom from gis.tl_20101117_101056_limite l)" (the_geom) sql=
When layer are in public's schema is OK.
... from public.tl_20101117_101056_limite l
Associated revisions
use both schema and table name retrieving oid, to fix #3329
fixed endian deduction corrupted in r13340
git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@14919 c8812cc2-4d05-0410-92ff-de0c093fc19c
use both schema and table name retrieving oid, to fix #3329
fixed endian deduction corrupted in r13340
git-svn-id: http://svn.osgeo.org/qgis/trunk@14919 c8812cc2-4d05-0410-92ff-de0c093fc19c
History
#1
Updated by Ricardo Silva about 14 years ago
- Status changed from Open to In Progress
Hi, I am the author of this plugin. I am aware of this error message. I haven't found its cause yet, but it seems to have no actual effect on the generation of the layers. I'll keep investigating and report back when I have a fix.
#2
Updated by Giuseppe Sucameli about 14 years ago
- Status changed from In Progress to Open
This is a postgres provider's error, not just a plugin one.
#3
Updated by Giuseppe Sucameli about 14 years ago
- Status changed from Open to In Progress
#4
Updated by Giuseppe Sucameli about 14 years ago
- Resolution set to fixed
- Status changed from In Progress to Closed
Fixed from 650d97b0 (SVN r14920)
#5
Updated by Ricardo Silva about 14 years ago
Just tested it against the 'custom db query' plugin. It's working great. Thanks a lot!