Bug in index creation

Started by Tim Newellover 26 years ago1 messagesbugs

TimothyNewell@xwavesolutions.com

over 26 years ago

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'

Show quoted text

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:
---------------------------------------------------------------------