artemp/tickets2issues — Issue #477: PostGIS driver doesn't grok quoted table names
Author: artemp
Created: 2011-10-11 15:20:06+00:00
State: open
Labels: PostGIS_Input_Driver

The PostGIS driver will apparently try to automagically parse the provided SQL to extract the table name, this doesn't work with quoted table names even though that's valid SQL, e.g.:

{{{

(select way from "view_planet_osm_line_lang_is" where "addr:interpolation" is not null) as interpolation

}}}

But this works:

{{{

(select way from view_planet_osm_line_lang_is where "addr:interpolation" is not null) as interpolation

}}}

Some table names need to be quoted, e.g. if they contain "-".