Hello hackers...

I tried this with version 6.4.2 and the current development tree.

ryan=> create table test (test int8 PRIMARY KEY);
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index test_pkey for table test
ERROR:  Can't find a default operator class for type 20.



I also tried this:

ryan=> create table test (i int8);
CREATE
ryan=> create index test_pkey on test (i);
ERROR:  Can't find a default operator class for type 20.



and this:

ryan=> create index test_pkey on test using btree (i int8_ops);
ERROR:  DefineIndex: int8_ops class not found


Finally I tried to cast it to an int4_ops to see what happened:

ryan=> create unique index test_pkey on test using btree (i int4_ops);
CREATE



looks good but...

ryan=> insert into test values (5);
INSERT 1133758 1

ryan=> insert into test values (5);
INSERT 1133759 1

ryan=> select * from test;
i
-
5
5
(2 rows)



Doesn't look quite right to me.   If no-one else is working on this, maybe 
this would be a good project for me to look into.

- Ryan


Sun, 14 Feb 1999 19:53:42 -0700 (MST)
Ryan Bradetich <rbrad@hpb50023.boi.hp.com>
Is the int8_ops being implimented?
> ryan=> create table test (test int8 PRIMARY KEY);
> NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index test_pkey for table test
> ERROR:  Can't find a default operator class for type 20.
> Doesn't look quite right to me.   If no-one else is working on this, 
> maybe this would be a good project for me to look into.

Sure, go ahead. If you run into trouble or want suggestions, let me know
since I have this on my ToDo list anyway...

                          - Thomas

Wed, 17 Feb 1999 15:32:04 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] Is the int8_ops being implimented?