Re: [GENERAL] Wrong starting value of sequences after doing pg_dump

2010-10-08 Thread Adrian Klaver
On 10/08/2010 11:17 AM, Dennis Gearon wrote: I did a pg_dump of a database. All the sequences ended up with starting values of 1. Since this is not an empty database, this is all wrong. Is there anything I need to do at command time to change that or is it a bug? \set in psql gives: PostgreS

[GENERAL] Wrong starting value of sequences after doing pg_dump

2010-10-08 Thread Dennis Gearon
I did a pg_dump of a database. All the sequences ended up with starting values of 1. Since this is not an empty database, this is all wrong. Is there anything I need to do at command time to change that or is it a bug? \set in psql gives: PostgreSQL 8.4.5 on x86_64-pc-linux-gnu, compiled by GC