[Qgis-developer] Error for postgres's provider when table(statement SELECT ) is outside public's schema

[Giuseppe Sucameli]

Hi Noli,
this one it's no a plugin error, it's a query syntax error.
On Thu, Dec 16, 2010 at 5:33 AM, Noli Sicad <nsicad at gmail.com> wrote:

> Select * from Regions where NAME = "VENETO"
>
You still use double quotes wrapping values, instead you must use single
quotes.
Double quotes are for identifiers like table name, schema name and column
name.

Cheers.

 On 12/16/10, Noli Sicad <nsicad at gmail.com> wrote:
> > Hi Ricardo,
> >
> > In postgis error.
> >
> > The plugin has the same problem when you checkbox is on for "save new
> > layer to database".
> >
> > However, if I unchecked it this is the error.
> >
> > ~~~~~~~~~~~~
> >
> > Unable to execute the query.
> > The error message from the database was:
> > ERROR:  column "A" does not exist
> > LINE 1: ...ect * from (Select * from stands where veg_type = "A") as
> "s...
> >                                                              ^
> > .
> > SQL: select * from (Select * from stands where veg_type = "A") as
> > "subQuery_0" limit 1
> >
> >
> > Noli
> >
> >
> >
> >
> > On 12/16/10, Noli Sicad <nsicad at gmail.com> wrote:
> >> Hi Ricardo,
> >>
> >> Spatialite database bug.
> >>
> >> The bug is in checkbox (on./check) "save new layer to database".
> >>
> >> When I unchecked (off), it works but the resulting map in TOC is "sql
> >> layer".
> >>
> >>
> >>
> >> The postgis bug, I don't know the reason since it does not work as
> >> well in the other postgis plugin (i.e PGManager).
> >>
> >> Noli
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> On 12/16/10, Ricardo Filipe Soares Garcia da
> >> <ricardo.garcia.silva at gmail.com> wrote:
> >>> Hi Noli
> >>>
> >>> I can't seem to reproduce any of your errors with my sample data.
> >>> Can you give me some more information? What queries are you trying?
> >>> Is it possible for you to send me some testing data?
> >>>
> >>> On Thu, Dec 16, 2010 at 1:47 AM, Noli Sicad <nsicad at gmail.com> wrote:
> >>>> Hi Ricardo,
> >>>> .
> >>>> I got another error in 0.4, this time in PostGI. This is simple query.
> >>>>
> >>>> Select * from stands where veg_type = "A"
> >>>>
> >>>> ~~~~~~~~~
> >>>> An error has occured while executing Python code:
> >>>>
> >>>> Traceback (most recent call last):
> >>>>  File
> >>>>
> "/home/noli/.qgis/python/plugins/customdbquery/CustomDBQueryDialog.py",
> >>>> line 175, in parse_SQL_text
> >>>>    self.execute_query(selectQuery)
> >>>>  File
> >>>>
> "/home/noli/.qgis/python/plugins/customdbquery/CustomDBQueryDialog.py",
> >>>> line 187, in execute_query
> >>>>    self.run_normal_query(createTableQuery, connection)
> >>>>  File
> >>>>
> "/home/noli/.qgis/python/plugins/customdbquery/CustomDBQueryDialog.py",
> >>>> line 238, in run_normal_query
> >>>>    cursor.execute(query)
> >>>> ProgrammingError: column "A" does not exist
> >>>> LINE 1: ...ne.Veg_TYPE_A AS (Select * from stands where veg_type =
> "A")
> >>>>                                                                  ^
> >>>>
> >>>>
> >>>> Python version:
> >>>> 2.6.5 (r265:79063, Apr 16 2010, 13:28:26)
> >>>> [GCC 4.4.3]
> >>>>
> >>>>
> >>>> QGIS version:
> >>>> 1.7.0-Trunk Trunk, 14914M
> >>>>
> >>>>
> >>>> The previous error was in Spatialite.
> >>>>
> >>>> Thanks.
> >>>>
> >>>> Noli
> >>>>
> >>>
> >>>
> >>>
> >>> --
> >>> ___________________________ ___ __
> >>> Ricardo Garcia Silva
> >>> _______________________________________________
> >>> Qgis-developer mailing list
> >>> Qgis-developer at lists.osgeo.org
> >>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
> >>>
> >>
> >
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>



-- 
Giuseppe Sucameli
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/qgis-developer/attachments/20101216/c1bacca9/attachment.html