[postgis-tickets] [PostGIS] #2284: standardize_address doesn't accept schema qualified table names

[PostGIS]

#2284: standardize_address doesn't accept schema qualified table names
---------------------------------+------------------------------------------
 Reporter:  robe                 |       Owner:  robe         
     Type:  defect               |      Status:  new          
 Priority:  medium               |   Milestone:  PostGIS 2.1.0
Component:  pagc_address_parser  |     Version:  trunk        
 Keywords:                       |  
---------------------------------+------------------------------------------
 This could be a problem for some folks especially if they keep data in
 separate schemas for logical partitioning and happen to have all their
 lex, gaz, rules tables named the same for consistency or to support
 multitenancy apps.

 Observe:

 {{{
 select (std).* from (
     select standardize_address('public.lex', 'public.gaz', 'public.rules',
 micro, macro) as std
       from addresses) as foo;
 }}}


 Yields error:

 {{{
 NOTICE:  load_lex: lex and gaz table names may only be alphanum and '_'
 (public.lex)


 ERROR:  CreateStd: failed to load 'public.lex' for lexicon


 ********** Error **********

 ERROR: CreateStd: failed to load 'public.lex' for lexicon
 SQL state: XX000

 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2284>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.