[Top][All Lists]

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

Re: [Gnumed-devel] Creating gnumed with sqls alone

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Creating gnumed with sqls alone
Date: Wed, 11 Jan 2006 21:50:33 +0100
User-agent: Mutt/1.5.11

On Tue, Jan 10, 2006 at 09:12:11PM +0800, Syan Tan wrote:

> it is possible.
Thanks :-)

> there is a line that executes a sql script within a sql script in
> gmDemographics-GIS-data.sql
> \i gmCountryZones.sql  , 
The reason for it being there had to do with some sort of
complexity while upgrading a v1 to a v2 database. That
reason wasn't very good, though. It's definitely not the
place it *should* be in, I agree.

> which implies one is running the sql script in the same directory as 
> execution,
I didn't think of that. A good counter-argument.

> and I moved that to the monolithic-core.conf  because  it means scripts which
> aren't configured
> with the relative path to the sql scripts will still run.

> I debugged
>     test-area/cygwin/ 
> what the script does is basically parses server/boostrap/
> boostrap-monolithic-core.conf for the basic setup
> information under $service ...$service  [database ..] [server..] [service
> SERVICENAME]  $schema ..$schema
> orders it and puts the order in "filelist", and dumps the sql in that order  
> to
> a file called "all'  , does some  setup
> using  the command line  createdb, createlang, createuser,  and then runs  
> psql
> -f  "all"  -U "gm-dbo" gnumed.
Sounds very reasonable.

> So it sort of proves what Karsten asserts. 

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

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