Re: [Gnumed-devel] Upgrade psql

[Vaibhav Banait]

Here it goes. kindly see attached files. 
Vaibhav Banait

-original message-
Subject: Re: [Gnumed-devel] Upgrade psql
From: Karsten Hilbert <address@hidden>
Date: 21/11/2013 9:10 pm

On Thu, Nov 21, 2013 at 08:48:48PM +0530, Vaibhav Banait wrote:

> select * from clin.v_substance_intakes where pk_episode = 555;
> 
> Results in error clin.v_Substance_intake(s) - no such entry exist in database 

Please try the following query against your v18 database:

        select * from clin.v_pat_substance_intake where pk_episode = 555;

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

PROBLEM.PNG
Description: PNG image

Quick report

Generated: 11/23/13 11:14:28
Database: gnumed_v18 on address@hidden:5433

Notes:

query report

Query results

pk_substance_intake	pk_patient	soap_cat	brand	preparation	substance	amount	unit	atc_substance	atc_brand	external_code_brand	external_code_type_brand	started	intake_is_approved_of	schedule	duration	discontinued	discontinue_reason	is_long_term	aim	episode	health_issue	notes	fake_brand	is_currently_active	seems_inactive	pk_brand	pk_data_source	pk_substance	pk_drug_component	pk_encounter	pk_episode	pk_health_issue	modified_when	modified_by	row_version	xmin_substance_intake
417	614	p	Vegaz-od	tablet	mesalazine	1.2	g	A07EC02				2013-10-02 11:16:19.279+05:30	t										f	t		27699		8306	27627	522	555		2013-10-02 11:17:09.527+05:30	vbanait	1	519031
418	614	p	FOLVITE 5 (Wyeth)	TAB	Folic Acid	5	mg	B03BB01				2013-10-02 11:17:10.279+05:30	t										f	t		14379		42	14306	522	555		2013-10-02 11:17:32.895+05:30	vbanait	1	519035

2 rows with 37 columns retrieved.

select* from clin.v_pat_substance_intake where pk_episode =555;

Report generated by pgAdmin III