Re: [BUGS] INDEX broken on NUMERIC type.

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: mschout(at)gkg(dot)net
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] INDEX broken on NUMERIC type.
Date: 1999-09-28 03:20:54
Message-ID: 199909280320.XAA28697@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gkg(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 1999-09-28 05:03:48 Re: [BUGS] 'Default' troubles again. This time with time :)))
Previous Message mschout 1999-09-28 02:40:27 INDEX broken on NUMERIC type.