X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DCE1ED1B484 for ; Wed, 31 Dec 2003 08:01:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 49078-06 for ; Wed, 31 Dec 2003 04:00:34 -0400 (AST) Received: from email.philnet (unknown [61.1.74.249]) by svr1.postgresql.org (Postfix) with ESMTP id AC47ED1B436 for ; Wed, 31 Dec 2003 04:00:12 -0400 (AST) Received: from OMKAR (omkar.philnet [172.16.1.163]) by email.philnet (8.11.6/8.11.2) with SMTP id hBV8FIP21077; Wed, 31 Dec 2003 13:45:20 +0530 Message-ID: <000201c3cf74$4db995f0$a30110ac@OMKAR> From: "omkar prabhu" To: Subject: PG_DUMP Date: Wed, 31 Dec 2003 13:31:18 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01C3CFA2.5F213810" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4927.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.8 tagged_above=0.0 required=5.0 tests=HTML_40_50, RCVD_IN_RFCI X-Spam-Level: * X-Archive-Number: 200401/17 X-Sequence-Number: 11880 This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C3CFA2.5F213810 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am trying to dump large object data( from a database containing table con= sist of 4 lo fields) I get following error. I am using postgres 7.2.1 which is installed from rpm Command use is=20 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 When i try restore using pg_restore Blob data is restored. Same i tried to postgres7.2.1 which is compiled and install it works fine. What could be the problem?=20 Is there anyway by which i can fixed this problem by using postgres which i= s installed using rpm ------=_NextPart_000_0016_01C3CFA2.5F213810 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I am trying to dump large object data( fro= m a=20 database containing table consist of 4 lo fields)

I get following error.

I am using postgres 7.2.1 which is install= ed from=20 rpm

Command use is

pg_dump -Ft -b test1 >=20 db.tar

I get following message

pg_dump: WARNING: function "lo_oid" not=20 dumped
pg_dump: reason: data type name of argument 0 (oid 16584) not=20 found

When i try restore using pg_restore=

Blob data is restored.

Same i tried to postgres7.2.1 which is com= piled and=20 install it works fine.

What could be = the problem?=20

Is there anyway by which i can fixed this = problem=20 by using postgres which is installed using rpm

------=_NextPart_000_0016_01C3CFA2.5F213810--