Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PostGIS driver doesn't grok quoted table names #393

Closed
artemp opened this issue Oct 11, 2011 · 2 comments
Closed

PostGIS driver doesn't grok quoted table names #393

artemp opened this issue Oct 11, 2011 · 2 comments

Comments

@artemp
Copy link
Member

artemp commented Oct 11, 2011

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 "-".

@artemp
Copy link
Member Author

artemp commented Oct 11, 2011

[springmeyer] thanks very much for the report. fixed in r1454

@artemp
Copy link
Member Author

artemp commented Oct 11, 2011

[springmeyer] see also #1708 (which will land in Mapnik 0.7.1)

@artemp artemp closed this as completed Oct 11, 2011
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant