[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] BILLABLE
From: |
Busser, Jim |
Subject: |
Re: [Gnumed-devel] BILLABLE |
Date: |
Thu, 9 May 2013 14:26:13 +0000 |
On 2013-05-09, at 6:19 AM, Vaibhav Banait <address@hidden> 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 > INSERT INTO ref.billable (code, term,
> fk_data_source, amount, currency) values
> ('1', 'First consultation', currval
> ('ref.data_source_pk_seq'), 300, U&'\20A8');
> ERROR: unsafe use of string constant with
> Unicode escapes SQL state: 0A000 Will you please help me out?
Hi …
Did the above result from your attempt to run the data pack locally
psql -d gnumed_vXX -U gm-dbo -f install-data-pack.sql
after first uncommenting
-- SET default_transaction_read_only TO OFF;
or did you try the above lines copied / pasted directly inside psql?
-- Jim
- Re: [Gnumed-devel] Billable, Vaibhav Banait, 2013/05/03
- Re: [Gnumed-devel] Billable, Vaibhav Banait, 2013/05/04
- Re: [Gnumed-devel] Billable, Vaibhav Banait, 2013/05/05
- Re: [Gnumed-devel] BILLABLE, Vaibhav Banait, 2013/05/09
- Re: [Gnumed-devel] BILLABLE, Vaibhav Banait, 2013/05/09
- Re: [Gnumed-devel] BILLABLE, Vaibhav Banait, 2013/05/11
- [Gnumed-devel] Billable, Sebastian Hilbert, 2013/05/11
- Re: [Gnumed-devel] BILLABLE, Vaibhav Banait, 2013/05/13