Re: [GENERAL] pg_migrator not setting values of sequences?

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 />