Re: [PORTS] Port Bug Report: no indexing allowed on int8 type

This is a known problem in 6.4, but will be fixed in 6.5 beta, which
should release in the next few weeks.

>
> ============================================================================
>                         POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
>
>
> Your name        : Bob Prowel
> Your email address    : rprowel@uswest.com
>
> Category        : runtime: back-end: SQL
> Severity        : non-critical
>
> Summary: no indexing allowed on int8 type
>
> System Configuration
> --------------------
>   Operating System   : Linux 2.2.2
>
>   PostgreSQL version : 6.4.2
>
>   Compiler used      : gcc 2.8.2
>
> Hardware:
> ---------
> Pentium 90 PCI, 32MB, SCSI/IDE
>
> Versions of other tools:
> ------------------------
> GNU tools supplied with Redhat Linux
>
> --------------------------------------------------------------------------
>
> Problem Description:
> --------------------
> create table users (uid int8 primary key, cuid varchar(16),
>     user_name varchar(50));
>
> generates error similar to
> "unknown default operator for type 20"
>
> failed table create also tricks psql into believing that the
> table was created even though it doesn't show up in the
> \dt list.  Must exit psql and reenter to clear the
> condition.
>
> When I change the uid int8 to an int4 the error goes away.
> This makes me question whether the long integer type was
> fully implemented in the SQL engine.
>
> --------------------------------------------------------------------------
>
> Test Case:
> ----------
> see above
>
> --------------------------------------------------------------------------
>
> Solution:
> ---------
> Guessing here: Check implementation of int8 type and make
> sure it has all needed operations properly defined???
> -- my dimes worth (inflation ya know)
>
> --------------------------------------------------------------------------
>
>
>


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