[Top][All Lists]

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

Re: [Gnumed-devel] Bits which seem to not work/missing

From: Syan Tan
Subject: Re: [Gnumed-devel] Bits which seem to not work/missing
Date: Wed, 11 Jan 2006 06:46:58 +0800

which compiler ?  what version of postgres ?

this runs on my installation, both via the normal bootstrap and the alternate test-area/cygwin/ script.

I have postgresql 8.0 running on a debian system; 

On Wed Jan 11 9:00 , Richard Terry sent:


In this table, my compile crashes at the places I've marked ****, the compile
stops and asks for a parameter input. Obviously if I comment out that line,
include a comma after not null, it compiles. Any ideas.

create table clin.vacc_def (
id serial primary key,
fk_regime integer
not null
references clin.vacc_regime(id)
on delete cascade
on update cascade,
is_booster boolean
not null
default false,
seq_no integer
default null,
min_age_due interval
not null
****check (min_age_due > '0 seconds'::interval),
max_age_due interval
default null
****check ((max_age_due is null) or (max_age_due >= min_age_due)),
min_interval interval
default null,
comment text,
unique(fk_regime, seq_no)

The gmClinical.Sql references table form_defs. I cannot find the construct for
this anywhere, certainly not in gmFormDefs.sql (which itself BTW comments
about gmFormData.sql which dosn't seem to exist in the CVS.

Also your gmDemographics.CIS-data.sql is missing all countries below United
States, but these are form some reason living in the file gmCountryZones.sql,
which in itself is somewhat of a misnomer, because it inserts all the data
into the states table. I'd suggest removing zambia, zimbabwe from there,
putting it back into gmDemogrpahics-GIS-data.sql and renaming gmCountryZones
to something like gmCountryStates.sql to at least reflect its content.

gmClinical.sql won't compile either for me because when it gets to the bottom
there are a whole lot of tables relating to forms, which reference formdefs
which of course seems not to exist (for me despite fresh cvs, and me
inspecting the cvs on the web).

Thanks for your comments/help.

Gnumed-devel mailing list

reply via email to

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