Re: pg_dump problem with PostgreSQL v7.1.2 - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: pg_dump problem with PostgreSQL v7.1.2
Date
Msg-id Pine.LNX.4.30.0107152159290.677-100000@peter.localdomain
Whole thread Raw
In response to pg_dump problem with PostgreSQL v7.1.2  (Dominick <haystack@email.rentzone.org>)
List pgsql-general
Dominick writes:

> I keep the same message when trying to dump any database. I haven't a clue; consequently, I'd appreciate any help
thatyou could provide. 
>
> postgres@ibook:/usr/local/pgsql/bin > ./pg_dump -o discuss -f /tmp/ibook_discuss_db
>
> getDatabase(): SELECT failed.  Explanation from backend: 'ERROR:  More than one tuple returned by a subselect used as
anexpression. 
> '.

You have more than one user in pg_shadow with the same id.  Assign a
different id to one of them.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: Extracting octets from an inet column
Next
From: geniusj@bluenugget.net
Date:
Subject: PASSWORD() function for postgresql?