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