On Wed, Dec 28, 2011 at 9:30 AM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > Wonder if it is related to this: > http://archives.postgresql.org/pgsql-bugs/2011-11/msg00098.php None of my sequences are named 'new'. What do you mean? > Might want to file bug report: > http://www.postgresql.org/support/submitbug/ > > In the meantime what about using 8.4 pg_dump to create dump file and then using > that file to load 9.1 server. That's an option. When I upgraded to PostgreSQL 9.1 on my Ubuntu 11.10 workstation, I noticed apt did not make me uninstall my old 8.4 version. Seemed happy to leave them both installed. I found a number of sequence fixing options: http://stackoverflow.com/questions/244243/how-to-reset-postgres-primary-key-sequence-when-it-falls-out-of-sync Right now I just have a long list of ALTER SEQUENCE sequence_name RESTART WITH (SELECT max(id) FROM table_name); to fix things up for me on my local setup. -- Greg Donald -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
