Re: [Gnumed-bugs] <bug>: adding brands

[Karsten Hilbert]

Hello Vaibhav,

thanks for your report.

> user comment  : adding brands
> 
> client version: 1.3.3

This:

> 2013-05-11 11:19:23  ERROR     gm.db 
> (d:\workplace\gnumed-client.1.3.3\build\pyi.win32\gnumed\outpyz1.pyz\gnumed.pycommon.gmpg2::run_rw_queries()
>  #1208): RW query failed: [INSERT INTO ref.branded_drug (description, 
> preparation) VALUES (E'Benadon', E'tablet') RETURNING pk]
> 2013-05-11 11:19:23  ERROR     gm.db 
> (d:\workplace\gnumed-client.1.3.3\build\pyi.win32\gnumed\outpyz1.pyz\gnumed.pycommon.gmpg2::run_rw_queries()
>  #1213): PG error message: ERROR:  duplicate key value violates unique 
> constraint "substance_brand_pkey"

means that you wanted to save a drug which already exists
(namely, Benadon). Since the phrasewheel shows existing
drugs when you type in a brand name I guess I wonder why.

As it just might have been some other error thanks for
your report anyway.

I have now improved GNUmed to show an explicit error message
when the brand to create already exists.

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