Re: [Gnumed-devel] psql upgrade

[Sebastian Hilbert]

Am Montag, 25. November 2013, 11:25:10 schrieb 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

Is it feasible to add these in a v18 database even now ? If I understand this 
correctly the upgrade from v18 to v19 would add these but I guess they are 
valid in a v18 production system as well ?

Sebastian