Bug in index creation
От | Tim Newell |
---|---|
Тема | Bug in index creation |
Дата | |
Msg-id | 012201bf08fa$a7edf7e0$33014bc0@w95-tim-n.atl.sofkin.ca обсуждение исходный текст |
Список | pgsql-bugs |
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: >--------------------------------------------------------------------- > > >
В списке pgsql-bugs по дате отправления: