Re: [Gnumed-devel] BILLABLE

[Karsten Hilbert]

On Thu, May 09, 2013 at 06:49:09PM +0530, Vaibhav Banait wrote:

> I get following errors when I execute
> following lines for adding
> billing items into gnumed > INSERT INTO ref.data_source (name_long,
> name_short, version, source) values
> ('Indian Billing', 'VBIB', '2013', 'Vaibhav
> Banait'); Error :ERROR: duplicate key value violates
> unique constraint "data_source_pkey"
> SQL state: 23505

Very likely you ran the script more than once and you
probably uncommented the following:

        -- finalize transaction --
        -- uncomment this once you are satisfied your script works:
        --COMMIT;
        -- ---------------------------------------------------------

before it was true ?

Attached find an improved script.

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

install-data-pack.Indian_Billing.sql
Description: application/sql