Bigint

Herb Blacker <herbblacker@isgenesis.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