Re: Bigint

Herb Blacker <herbblacker(at)isgenesis(dot)com> writes:
> I'm running version 7.1.3.
> I've defined a table with a 'bigint' field (as described in the
> Reference manual),
> and the table creation fails with:
> -- psql:createDeviceTable.sql:9: ERROR: Unable to locate type name
> 'bigint' in catalog

You sure you're on 7.1? It works for me:

test71=# create table foo (f1 bigint);
CREATE
test71=# select version();
version
------------------------------------------------------------------
PostgreSQL 7.1.3 on hppa2.0-hp-hpux10.20, compiled by GCC 2.95.3
(1 row)

OTOH 7.0 would give exactly that error message ...

regards, tom lane