Re: [Gnumed-devel] Country zones and i18n

[Karsten Hilbert]

On Tue, Nov 15, 2011 at 01:17:41AM +0000, Jim Busser wrote:

> > 2) following the recreation of Canadian provinces I issued
> > 
> >     select dem.gm_upd_default_states();
> 
> Trying to understand why / when this function is used…
> 
> What it appears to do is to try to ensure that in the event that where the 
> table
> 
>       dem.state
> 
> did not already otherwise contain -- for each country -- a state with 
> abbreviation (code) and name
> 
>       ??
>       state/territory/province/region not available
> 
> then this function, when called, will ensure that such 'placeholder' '??' 
> states get created. However there seems little point to use / call it except:
> 
> 
> 1) when the function was (originally) first being implemented

Indeed, except that one Best Practice in IT is to automate
what you expect to use every so often.

> 2) after adding/ creating one or more new countries (having new country 
> codes) or

Yes.

> 3) after deleting any states (in case any of the deletions included a state 
> of code '??')

Yes.

> and therefore after I went and deleted entire sets of states would be the 
> time to call that function… is this correct?

Correct !

BTW, the sole reason de etre for the

        "??" / "state/territory/province/region not available"

fake state entries is to allow entering addresses when the/a
region is not known for a country/community combination.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346