Error from pg_dump - Mailing list pgsql-general

From Steve Wolfe
Subject Error from pg_dump
Date
Msg-id 00cd01c01901$545e45e0$50824e40@iboats.com
Whole thread Raw
In response to Re: php and pgsql and rpm/compile  (Tressens Lionel <tressens@etud.insa-tlse.fr>)
List pgsql-general
  Yesterday, when our nightly database backup was running, it errored out
with the following error from pg_dumpall:

dumpSequence(contact_seq): different sequence name returned by SELECT:
contact_sequence


  Now, there isn't a sequence called "contact_sequence".  There's one called
"contact_seq", and the contact table references it like this:

    Attribute    |     Type     |                   Modifier
-----------------+--------------+------------------------------------------
 contact_id      | integer      | not null default
nextval('contact_seq'::text)


  What exactly does this error mean, and how I can track down what is
causing it?

steve



pgsql-general by date:

Previous
From: "Adam Lang"
Date:
Subject: Re: php and pgsql and rpm/compile
Next
From: Lamar Owen
Date:
Subject: Re: php and pgsql and rpm/compile