From: pginfo <pginfo@t1.unisoftbg.com>
To: pgsql-admin@postgresql.org
Subject: problem with pg_dump
Date: Sun, 13 Jun 2004 08:37:30 +0200
Message-ID: <40CBF62A.3000602@t1.unisoftbg.com> (raw)
Hi all,
We are using pg as db for many erp installations.
In general it is working great.
But at the monet I have problem (I think it is database corrupted, but I
am not sure) by running pg_dump.
I receive this message:
pg_dump acc01 > dmpacc01
pg_dump: query to obtain list of data types failed: ERROR: More than
one tuple returned by a subselect used as an expression.
I can not find nothink wong in my log-file. The lastest records are:
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2004-06-13 09:39:03 EEST
LOG: checkpoint record is at 3/313382E4
LOG: redo record is at 3/313382E4; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 4046855; next oid: 958527775
LOG: database system is ready
WARNING: ROLLBACK: no transaction in progress
WARNING: ROLLBACK: no transaction in progress
WARNING: ROLLBACK: no transaction in progress
WARNING: ROLLBACK: no transaction in progress
WARNING: ROLLBACK: no transaction in progress
WARNING: ROLLBACK: no transaction in progress
WARNING: ROLLBACK: no transaction in progress
WARNING: ROLLBACK: no transaction in progress
WARNING: ROLLBACK: no transaction in progress
WARNING: ROLLBACK: no transaction in progress
WARNING: ROLLBACK: no transaction in progress
ERROR: More than one tuple returned by a subselect used as an expression.
We are using pg 7.3.4 for this install (we will upgrade to 7.4.x soon).
Pls. help me to sort out this problem. It is production db and is
important to resolve the problem.
regards,
ivan.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pginfo@t1.unisoftbg.com
Subject: Re: problem with pg_dump
In-Reply-To: <40CBF62A.3000602@t1.unisoftbg.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox