I am testing the uuid datatype with unique indexing.
I have the following script to generate a table with uuid types:
create table guid(
pk uuid primary key default new_guid(),
f1 varchar(38)
);
insert into guid(f1) values('bla bla');
insert into guid(f1) values('bla bla');
insert into guid(f1) select f1 from guid;
-- I repeat the insert above 10 times to get may records.
-- then save the generated guid into the varchar field
update guid set f1=pk;
-- check for duplicates in the varchar field
select f1,count(*) from guid group by f1 having(count(f1) > 1);
-- no duplicates there:
f1 | count
----+-------
(0 rows)
-- and here it comes.........
dev=# create unique index idx1 on guid using btree (pk);
ERROR: could not create unique index
DETAIL: Table contains duplicated values.
I must be doing something very wrong.....
Does anyone ever seen such a thing?
Regards,
Gevik.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
