[Gnumed-devel] Country zones and i18n

[Busser, Jim]

I messed up on a large org import and as a result created numerous addresses 
whose newly created cities (urbs) got mapped to a state abbreviation which did 
not, in all cases, represent the state from the correct country (on account of 
state abbreviations being not distinct across countries).

Anyhow, in my database, I deleted all

        addresses
        streets
        urbs
        states

except for those that were foreign-key referenced by

        patients (persons)
        clin.test_orgs

I then located

        
~/git/gnumed/gnumed/gnumed/server/sql/country.specific/ca/gmDemographics-Data.ca.sql
        ~/git/gnumed/gnumed/gnumed/server/sql/gmCountryZones.sql

and via psql recreated

        Canadian provinces (which in the .ca file include an i18n french 
translation)

        American states (from GmCountryZones.sql)

Questions:

1) when issuing an sql command like

        insert into dem.state (code, country, name) values ('AB', 'CA', 
i18n.i18n('Alberta')); 

        --> does the i18n.i18n establish an original 
'able-to-be-translated-term' despite that
                no actual translation might be offered until some later time?


2) following the recreation of Canadian provinces I issued

        select dem.gm_upd_default_states();

but when I tried to issue

        -- do simple revision tracking
        delete from gm_schema_revision where filename = '$RCSfile: 
gmDemographics-Data.ca.sql,v $';
        INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: 
gmDemographics-Data.ca.sql,v $', '$Revision: 1.5 $');

I got

        ERROR: relation "gm_schema_revision" does not exist 

?? is that obsolete (the Canadian sql was from 2006)

-- Jim