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');
Gevik Babakhani [EMAIL PROTECTED] writes:
I must be doing something very wrong.
Does anyone ever seen such a thing?
Your comparison functions for uuid are inconsistent.
regards, tom lane
---(end of broadcast)---
TIP
Thank you Tom :)
I was doing strncmp at some point but it did not work because
of the '\0'. I have created a custom comparison function and it seems to
work. I am now inserting 6 million records to see if it will break again
and start the other tests from scratch.
Thank you for your help.
Gevik Babakhani [EMAIL PROTECTED] writes:
I was doing strncmp at some point but it did not work because
of the '\0'. I have created a custom comparison function and it seems to
work.
Perhaps you just need memcmp instead of strncmp?
regards, tom lane
I followed your advice 6 million records are inserted without any
problems :)
Thank you.
On Sat, 2006-09-16 at 14:03 -0400, Tom Lane wrote:
Gevik Babakhani [EMAIL PROTECTED] writes:
I was doing strncmp at some point but it did not work because
of the '\0'. I have created a custom