Re: Unique UUID value - PostgreSQL 9.2

["drum.lucas@xxxxxxxxx" <drum.lucas@xxxxxxxxx>]

On the target table, I've got a CONSTRAINT:

ALTER TABLE dm.billables
  ADD CONSTRAINT uc_billable_code_unique_per_account UNIQUE("account_id", "code");

So I'm importing a CSV file with repeated values on the field "code"

Example:

'Interpreting Normal/AH'
'Interpreting Normal/AH'
'Interpreting Normal/AH'
'Interpreting Normal/AH'
'Interpreting Normal/AH4'
'Interpreting Normal/AH'
'Interpreting Normal/AH6'
'Interpreting Normal/AH'

So when importing it to the target table I got the error:

ERROR:  duplicate key value violates unique constraint "uc_billable_code_unique_per_account"
DETAIL:  Key ("account_id", "code")=(32152, 'Interpreting Normal/AH') already exists.

Command used to import the values:

INSERT INTO dm.billables (SELECT billable_id, code, info FROM temptable)

OR directly through the CSV file:

COPY dm.billables (code, info, unit_cost, unit_price, account_id) FROM '/var/lib/pgsql/sql/lucas/charge_test.csv' WITH DELIMITER ',' QUOTE '"' CSV HEADER;

So. I determined that to do that without dropping the CONSTRAINT, I'll have to generate a unique but random value to the "code" column.

NOW:

COLUMN CODE                                |       COLUMN INFO

'Interpreting Normal/AH'                            Travel1

'Interpreting Normal/AH1'                            trip2

'Interpreting Normal/AH2'                            test897

'Interpreting Normal/AH3'                            trip11

'Interpreting Normal/AH4'                            trave1

NEW:

COLUMN CODE                                |       COLUMN INFO

code_32152563bdc6453645                            Travel1

code_32152563bdc4566hhh                            trip2

code_32152563b654645uuu                           test897

code_32152563bdc4546uui                            trip11

code_32152563bdc4db11aa                            trave1

How can I do that?

I could also drop the COSNSTRAINT, import all the data and then change the "code" column to use UUID - But how?