[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-devel] Country zones and i18n

From: Busser, Jim
Subject: [Gnumed-devel] Country zones and i18n
Date: Mon, 14 Nov 2011 22:36:10 +0000

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


except for those that were foreign-key referenced by

        patients (persons)

I then located


and via psql recreated

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

        American states (from GmCountryZones.sql)


1) when issuing an sql command like

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

        --> 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:,v $';
        INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile:,v $', '$Revision: 1.5 $');

I got

        ERROR: relation "gm_schema_revision" does not exist 

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

-- Jim

reply via email to

[Prev in Thread] Current Thread [Next in Thread]