"mike" <matrix@quadrent.net> writes:
> dumpSequence(pilgram_en_id_seq): different sequence name returned by SELECT=
> : pilgram_cross_id_seq
> I'm not sure what this means, and I have no idea how to corect it.
Looking at the source code, it would seem that pg_dump is unhappy
because "SELECT sequence_name FROM pilgram_en_id_seq" returned
"pilgram_cross_id_seq" instead of the expected "pilgram_en_id_seq".
I'm not sure why exactly pg_dump is bothering to make such a
cross-check, but probably the more interesting question is how the
sequence got that way. Did you rename it at some point?
I find that "ALTER TABLE RENAME" will work without complaint on a
sequence. Seems we should either
(a) prohibit renaming a sequence;
(b) improve ALTER TABLE RENAME to know about changing the
sequence_name field as well;
(c) remove this cross-check from pg_dump; and/or
(d) remove the sequence_name field from sequences entirely.
(c) looks like the path of least resistance. I don't like (d) because
of the risk of breaking existing application code that might look at
the contents of sequences. Comments?
regards, tom lane