Re: PG_DUMP - LO PROBLEM

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: omkar prabhu <oprabhu(at)phildigital(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PG_DUMP - LO PROBLEM
Date: 2004-01-05 09:16:24
Message-ID: 20040105091624.GD13231@zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Dec 31, 2003 at 02:07:01PM +0530, omkar prabhu wrote:
> Hi,
>
>
> I am trying to dump large object data( from a database containing table consist of 4 lo fields)
> I get following error.
> I am using postgres 7.2.1 which is installed from rpm
> Command use is
> pg_dump -Ft -b test1 > db.tar
>
> I get following message
> pg_dump: WARNING: function "lo_oid" not dumped
> pg_dump: reason: data type name of argument 0 (oid 16584) not found

See and try the "pg_dumplo" from contrib tree. Maybe it help you.

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stef 2004-01-05 10:38:05 Re: ERD tool for postgres?
Previous Message Michael Glaesemann 2004-01-05 06:01:04 Re: [HACKERS] IEEE 754