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
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
-
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 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)---
TI
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');
inser
