Re: [BUGS] INDEX broken on NUMERIC type. - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: [BUGS] INDEX broken on NUMERIC type.
Date
Msg-id 199909280320.XAA28697@candle.pha.pa.us
Whole thread Raw
In response to INDEX broken on NUMERIC type.  (mschout@gkg.net)
List pgsql-bugs
We don't support it yet.  It is on the TODO list.



> ============================================================================
>                         POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
>
>
> Your name        : Michael Schout
> Your email address    : mschout@gkg.net
>
>
> System Configuration
> ---------------------
>   Architecture (example: Intel Pentium)      : Intel Pentium-II
>
>   Operating System (example: Linux 2.0.26 ELF)     : Linux 2.2.12 ELF
>
>   PostgreSQL version (example: PostgreSQL-6.5.2): PostgreSQL-6.5.2
>
>   Compiler used (example:  gcc 2.8.0)        : gcc egcs-2.91.66
>
>
> Please enter a FULL description of your problem:
> ------------------------------------------------
>
> NUMERIC type cannot be used in an INDEX.
>
> Please describe a way to repeat the problem.   Please try to provide a
> concise reproducible example, if at all possible:
> ----------------------------------------------------------------------
>
> Method (1) using primary key syntax:
> scdrought=> create table foo ( f1 NUMERIC(3,0) primary key );
> NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'foo_pkey' for table 'foo'
> ERROR:  Can't find a default operator class for type 1700.
>
>
> Method (2) do it by hand.
> mschout=> create table foo (f1 NUMERIC(3,0));
> CREATE
> mschout=> CREATE UNIQUE INDEX foo_pkey ON foo (f1);
> ERROR:  Can't find a default operator class for type 1700.
>
> If you know how this problem might be fixed, list the solution below:
> ---------------------------------------------------------------------
>
>
> ************
>
>


--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-bugs by date:

Previous
From: mschout@gkg.net
Date:
Subject: INDEX broken on NUMERIC type.
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] 'Default' troubles again. This time with time :)))