standardize_address doesn't accept schema qualified table names

[robe]

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

[robe]

Also need to support this syntax:

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

Since if people are anal enough or crazy enought to use mixed case in their tables they'll want/need to quote their tables and their schemas

[woodbri]

The current code supports the following syntax:

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

I can probably allow '"' chars to be ok also.

[woodbri]

Updated in revision 357. to allow " chars.