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

Re: Problem with sequences on a reload of a pg_dump file

From: Yannick LOUVET <y(dot)louvet(at)atolcd(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with sequences on a reload of a pg_dump file
Date: 2004-05-28 15:22:35
Message-ID: 40B7593B.3040500@atolcd.com (view raw or flat)
Thread:
Lists: pgsql-general
non non c plus possible
va falloir penser à arreter tout de même !!!!


Sean Shanny wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend


In response to

pgsql-general by date

Next:From: xierDate: 2004-05-28 15:56:21
Subject: Re: PostgreSQL delete the blank in the end of the String
Previous:From: Paul ThomasDate: 2004-05-28 13:39:20
Subject: Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

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