Re: [Gnumed-devel] BILLABLE

[Busser, Jim]

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