Dne 14.07.09 04:37, Bruce Momjian napsal(a): <blockquote cite="mid:200907140237.n6E2b2x27210@momjian.us"
type="cite"><prewrap="">Tom Lane wrote: </pre><blockquote type="cite"><pre wrap="">Bruce Momjian <a
class="moz-txt-link-rfc2396E"href="mailto:bruce@momjian.us"><bruce@momjian.us></a> writes: </pre><blockquote
type="cite"><prewrap="">Tilmann Singer wrote: </pre><blockquote type="cite"><pre wrap="">However, all of the
sequenceswere at the initial values and not
bumped up to the last used value as I would have expected. The first
nextval call on any sequence in the migrated 8.4 database always
returned 1. </pre></blockquote></blockquote><blockquote type="cite"><pre wrap="">Wow, that is also surprising. I
amgoing to have to run some tests to
find the cause, but it certainly is not intended. </pre></blockquote><pre wrap="">Looks like pg_migrator neglects
toinclude relkind 'S' in the set of
tables that it needs to physically migrate. </pre></blockquote><pre wrap="">
Thanks, I have fixed pg_migrator with the attached patch. Once we find
the cause of the lovacuum problem, I will make a new pg_migrator release.
</pre></blockquote> I think you don't need transfer sequence table, because pg_dump should create DDL command (CREATE
SEQUENCE)which should create new nice sequence relation.<br /><br /> Zdenek<br />