Thread

Bug in index creation

Tim Newell <timothynewell@xwavesolutions.com> — 1999-09-27T15:12:04Z

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@xwavesolutions.com
(902) 481-4572

-----Original Message-----
From: Tim Newell <newell@sol02.atl.sofkin.ca>
To: newell@atl.sofkin.ca <newell@atl.sofkin.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@postgresql.org.
>
>To report any other bug, fill out the form below and e-mail it to
>pgsql-bugs@postgresql.org.
>
>If you not only found the problem but solved it and generated a patch
>then e-mail it to pgsql-patches@postgresql.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@xwavesolutions.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:
>---------------------------------------------------------------------
>
>
>