Re: [Gnumed-devel] psql upgrade

[Karsten Hilbert]

On Mon, Nov 25, 2013 at 09:30:53AM +0100, Hilbert, Sebastian wrote:

> > > is a large data which I can not capture onto the image.
> > 
> > Please do the following steps:
> > 
> >     Open a command-prompt (terminal) session.
> >     Type in the following, and include the resulting file in your mail:
> > 
> > Note that this will not work in that way on Windows.
> 
> What makes you think it will not work that way in Windows ?

Compare the two commandlines:

        psql -U gm-dbo -d gnumed_v19 -c '\d clin.substance_intake' > 
substance_intake.txt
        C:\WINDOWS\Temp>c:\Programme\PostgreSQL\9.3\bin\psql.exe -U gm-dbo -d 
gnumed_v19 -c "\d clin.substance_intake" > substance_intake.txt

I only provided the first one.

> Fremdschl?ssel-Constraints:
...
>     "substance_intake_fk_encounter_fkey" FOREIGN KEY (fk_encounter) 
> REFERENCES clin.encounter(pk) ON UPDATE CASCADE ON DELETE RESTRICT
>     "substance_intake_fk_episode_fkey" FOREIGN KEY (fk_episode) REFERENCES 
> clin.episode(pk) ON UPDATE CASCADE ON DELETE RESTRICT

Those two are lacking from Vaibhav's database.

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