Re: [Gnumed-devel] BILLABLE

[Sebastian Hilbert]

Am Donnerstag, 9. Mai 2013, 18:49:09 schrieb Vaibhav Banait:

> 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?

> Vaibhav

 

Please let us know how you attempted to insert the data. Did you use pgadmin or psql command line ?

 

Which postgres account did you use for inserting the data etc.

 

A step by step description would help since it would let us reproduce what you did.

 

Sebastian