Re: Bigint - Mailing list pgsql-general

From Tom Lane
Subject Re: Bigint
Date
Msg-id 11078.1016053654@sss.pgh.pa.us
Whole thread Raw
In response to Bigint  (Herb Blacker <herbblacker@isgenesis.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Steve Lane
Date:
Subject: Re: Last Insert
Next
From: Joseph Koenig
Date:
Subject: Re: cannot initdb