Re: pg_dump problem with PostgreSQL v7.1.2

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Dominick <haystack(at)email(dot)rentzone(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump problem with PostgreSQL v7.1.2
Date: 2001-07-15 20:00:19
Message-ID: Pine.LNX.4.30.0107152159290.677-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 that you could provide.
>
> postgres(at)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 an expression.
> '.

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(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2001-07-15 20:03:41 Re: Extracting octets from an inet column
Previous Message Alex Pilosov 2001-07-15 19:50:18 Re: BYTEA data type