Re: [ADMIN] int8 regression fails on Irix 6.4

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: kim(at)mpiz-koeln(dot)mpg(dot)de (Jan Kim)
Cc: pgsql-admin(at)postgreSQL(dot)org
Subject: Re: [ADMIN] int8 regression fails on Irix 6.4
Date: 1999-01-12 19:38:56
Message-ID: 199901121938.OAA15275@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Dear Postgres Admins,
>
> failing to install PostgreSQL 6.4.2 on our Digital Alpha workstations,
> I tried to get it running on a Silicon Graphics Octane running Irix 6.4.
> Here, I managed to compile, install and test the basic backend function,
> but the regression test revealed that the int8 type is broken. It
> appears that no matter what values are inserted, they all appear as
> 9223091371479335140. Also, I found that no indices can be created
> on int8 type keys:
>
> postgres=> create table a (b int8);
> CREATE
> postgres=> create index c on a(b);
> ERROR: Can't find a default operator class for type 20.
>
> Any ideas on this problem? Many thanx in advance.

We don't have indexes for int8 yet. Sorry.

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

Browse pgsql-admin by date

  From Date Subject
Next Message John Goerzen 1999-01-12 21:00:05 Terrible upgrade experience
Previous Message Jan Kim 1999-01-12 18:58:11 int8 regression fails on Irix 6.4