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