| From: | "Bryan White" <bryan(at)arcamax(dot)com> |
|---|---|
| To: | <asbjs(at)stud(dot)ntnu(dot)no>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Errors with pg_dump |
| Date: | 2000-10-06 21:32:55 |
| Message-ID: | 007b01c02fdc$fd6c07c0$2dd260d1@arcamax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>
> I would like to move some data from an older installation of PostgreSQL to
> a newer. When doing
> "pg_dump persondb > db.out" I get the following error message:
>
> "dumpSequence(person_sek): 0 (!=1) tuples returned by SELECT"
>
> The "person_sek" is a sequence in the database.
>
I believe sequences are implemented as a separate with one row that contains
the sequence parameters and state. It looks like somehow that one row has
been deleted and pg_dump expects it to be there.
Is this sequence being used by your program and is it functioning correctly?
Can you do a select nextval('person_sek')?
If you need the sequence and you know what its current value and other
parameters should be then I suggest droping and recreating the sequence.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-10-06 21:36:43 | Re: Errors with pg_dump |
| Previous Message | Tom Lane | 2000-10-06 21:29:54 | Re: Blown Index? Corrupted Table? |