Bug in index creation

Below is a bug report describing a problem I encountered trying to create
primary
keys / indices on some basic tables using Postgres 6.5.2.

Thanks,
Tim Newell

Tim Newell
xwave solutions
timothynewell(at)xwavesolutions(dot)com
(902) 481-4572

-----Original Message-----
From: Tim Newell <newell(at)sol02(dot)atl(dot)sofkin(dot)ca>
To: newell(at)atl(dot)sofkin(dot)ca <newell(at)atl(dot)sofkin(dot)ca>
Date: Monday, September 27, 1999 12:10 PM

>If PostgreSQL failed to compile on your computer or you found a bug that
>is likely to be specific to one platform then please fill out this form
>and e-mail it to pgsql-ports(at)postgresql(dot)org(dot)
>
>To report any other bug, fill out the form below and e-mail it to
>pgsql-bugs(at)postgresql(dot)org(dot)
>
>If you not only found the problem but solved it and generated a patch
>then e-mail it to pgsql-patches(at)postgresql(dot)org instead. Please use the
>command "diff -c" to generate the patch.
>
>You may also enter a bug report at http://www.postgresql.org/ instead of
>e-mail-ing this form.
>
>===========================================================================
=
> POSTGRESQL BUG REPORT TEMPLATE
>===========================================================================
=
>
>
>Your name : Tim Newell
>Your email address : timothynewell(at)xwavesolutions(dot)com
>
>
>System Configuration
>---------------------
> Architecture (example: Intel Pentium) : Intel Pentium
>
> Operating System (example: Linux 2.0.26 ELF) : Linux 2.0.35 ELF
>
> PostgreSQL version (example: PostgreSQL-6.5.2): PostgreSQL-6.5.2
>
> Compiler used (example: gcc 2.8.0) : gcc 2.7.2.3
>
>
>Please enter a FULL description of your problem:
>------------------------------------------------
>
>Creation of indices in general, and specifically primary keys during
>table creation, fails with the error:
>
>ERROR: Can't find a default operator class for type 1700.
>
>Platform is Red Hat Linux 5.1 running kernel 2.0.35, Intel Pentium.
>Downloaded Postgres 6.5.2 tarball, configured using:
>./configure --with-tcl --with-perl --with-odbc
>
>Built and installed. Regression tests were fine (geometry tests
>generated a fail, but I believe that is just a precision / rounding
>error). Tried running our table create scripts (worked fine in
>Postgres 6.4.2), got errors for every table with a primary key, such as:
>
>ipbilling=> create table ACCESS_CODE (
>ipbilling-> ACC_SEQ_NO decimal(9) primary key,
>ipbilling-> ACC_ACCESS_CODE character varying (12) not null,
>ipbilling-> ACC_ROOM_NO character varying (10) not null,
>ipbilling-> ACC_VALID_FROM_DT timestamp not null,
>ipbilling-> ACC_VALID_TO_DT timestamp not null,
>ipbilling-> ACC_CREATED_DT timestamp not null
>ipbilling-> );
>NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
'access_code_pkey' for table 'access_code'
>ERROR: Can't find a default operator class for type 1700.
>
>Dropped the primary key constraint, and the table created fine (see next
>section). Tried creating an index manually on the same field, and it
>failed as well.
>
>
>
>Please describe a way to repeat the problem. Please try to provide a
>concise reproducible example, if at all possible:
>----------------------------------------------------------------------
>
>ipbilling=> create table ACCESS_CODE (
>ipbilling-> ACC_SEQ_NO decimal(9),
>ipbilling-> ACC_ACCESS_CODE character varying (12) not null,
>ipbilling-> ACC_ROOM_NO character varying (10) not null,
>ipbilling-> ACC_VALID_FROM_DT timestamp not null,
>ipbilling-> ACC_VALID_TO_DT timestamp not null,
>ipbilling-> ACC_CREATED_DT timestamp not null
>ipbilling-> );
>CREATE
>ipbilling=> create unique index test_index on access_code (acc_seq_no);
>ERROR: Can't find a default operator class for type 1700.
>
>
>
>
>If you know how this problem might be fixed, list the solution below:
>---------------------------------------------------------------------
>
>
>