Skip site navigation (1) Skip section navigation (2)

Problem with sequences on a reload of a pg_dump file

From: Sean Shanny <shannyconsulting(at)earthlink(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with sequences on a reload of a pg_dump file
Date: 2004-05-26 20:00:37
Message-ID: 40B4F765.5000904@earthlink.net (view raw or flat)
Thread:
Lists: pgsql-general
To all,

We dumped our instance from a 7.4.2 instance compiled with a block size 
of 32k running on OSX 10.3.3 server..  We loaded this dump on Fedora 
2.6.5-1.358smp running postgresql 7.4.2 compiled with the standard 8k 
blocks size.

My problem is that all the sequences were reset to start a 1. :-(   Did  
I do something wrong as this has never happened before?  Also, can I 
simply figure out what the  next value should be and manually update the 
last_value column in each affected sequence?

Thanks.

--sean

Responses

pgsql-general by date

Next:From: Lee HarrDate: 2004-05-26 20:11:33
Subject: Re: Remote X viewing of pgaccess
Previous:From: Ericson SmithDate: 2004-05-26 19:59:42
Subject: Re: Postgresql Logging

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group