Thread: Bigint

Bigint

From
Herb Blacker
Date:
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

So....whassssup?
_________________________

Herb Blacker
Database Administrator
ReCare, Inc.
(512) 791-4340
herbblacker@isgenesis.com


Re: Bigint

From
Tom Lane
Date:
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