Bug report #3329
Error for postgres's provider when table(statement SELECT ) is outside public's schema
|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|
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.
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
#1 Updated by Ricardo Silva over 10 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.