Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dump error message

pg_dump error message

From
"Joseph"
Date:
Trying to do a dump I get this error:

pg_dump -v database > backup
--  last builtin oid is 1
--  reading user-defined types
--  reading user-defined functions
--  reading user-defined aggregates
getAggregates(): SELECT failed.  Explanation from backend: 'ERROR:
Attribute 'aggtransfn1' not found
'.

How can I repair this?

Postgres 7.1.2
RH 6.2

respectfully,
Joseph

Re: pg_dump error message

From
Peter Eisentraut
Date:
Joseph writes:

> pg_dump -v database > backup
> --  last builtin oid is 1
> --  reading user-defined types
> --  reading user-defined functions
> --  reading user-defined aggregates
> getAggregates(): SELECT failed.  Explanation from backend: 'ERROR:
> Attribute 'aggtransfn1' not found
> '.

Use the pg_dump that came with 7.1.  Check your PATH.

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