Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to majordomo@postgresql.org so that your
     message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux