Hey, with this new ALTER SEQUENCE patch, how about this for an idea:
I submitted a patch to always generate non-colliding index and sequence
names. Seemed like an excellent idea. However, 7.3 dumps tables like this:
CREATE TABLE blah a SERIAL
);
SELECT SETVAL('blah_a_seq', 10);
Sort of thing...
How about we add a new form to ALTER SEQUENCE <sequence> ...?
ALTER SEQUENCE ON blah(a) CURRVAL 10.... (or whatever the syntax is)
or even
ALTER SERIAL ON blah(a)...
Which would allow us to dump tables in an environment where you do now know
exactly what the generated name will be...
Chris