Re: Bigint in sequences

Garo Hussenjian <garo(at)xapnet(dot)com> writes:
> I'm using pg_dump to port a database from one server to another, and I've
> found that the max_value of several sequences are 9223372036854775807 (type
> bigint), but most of the sequences' max_values are 2147483647 (also bigint,
> but not so big...). The larger value is causing errors when I try to import
> the database.
> Does this have to do with the OS or the postgres version? The source
> database is version 7.2.1, and the destination is 7.1.3. Did 7.2 raise the
> upper limit of bigint?

No, but sequences were based on int before 7.2. You seem to have
a mix of sequences dumped-and-reloaded from 7.1 and sequences made
natively in 7.2. If you want to load this dump in 7.1, I'd recommend
just editing out the clauses that specify the sequence upper limit ---
these are really all "default" anyway.

As a general rule, back-porting PG databases to older versions is a
recipe for headaches. My real recommendation is to update the
destination machine to 7.2.2 ;-)

regards, tom lane