Bug report #3329

Error for postgres's provider when table(statement SELECT ) is outside public's schema

Added by Luiz Motta almost 9 years ago. Updated almost 9 years ago.

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

Revision de0a1f8a
Added by Giuseppe Sucameli almost 9 years ago

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/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

Revision 650d97b0
Added by Giuseppe Sucameli almost 9 years ago

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/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

History

#1 Updated by Ricardo Silva almost 9 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 almost 9 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 almost 9 years ago

  • Status changed from Open to In Progress

#4 Updated by Giuseppe Sucameli almost 9 years ago

  • Resolution set to fixed
  • Status changed from In Progress to Closed

Fixed from 650d97b0 (SVN r14920)

#5 Updated by Ricardo Silva almost 9 years ago

Just tested it against the 'custom db query' plugin. It's working great. Thanks a lot!

Also available in: Atom PDF