problem with pg_dump

From: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: problem with pg_dump
Date: 2004-06-13 06:37:30
Message-ID: 40CBF62A.3000602@t1.unisoftbg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2004-06-13 21:24:36 Re: which system tables govern access privileges?
Previous Message Harry Stangel 2004-06-13 03:30:18 which system tables govern access privileges?