X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2EE189DC8D9 for ; Thu, 29 Dec 2005 03:44:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67324-01 for ; Thu, 29 Dec 2005 03:44:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 39DF39DC8AD for ; Thu, 29 Dec 2005 03:44:51 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id jBT7iieJ007483 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 29 Dec 2005 00:44:48 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id jBT7iiY3046689; Thu, 29 Dec 2005 00:44:44 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id jBT7igw2046688; Thu, 29 Dec 2005 00:44:42 -0700 (MST) (envelope-from mfuhr) Date: Thu, 29 Dec 2005 00:44:42 -0700 From: Michael Fuhr To: sandhya Cc: postgre Subject: Re: reading reading files from the DB Message-ID: <20051229074442.GA46583@winnie.fuhr.org> References: <03b301c60b9f$3fff4f40$cd00000a@amiindiahjwbgh> <20051229044734.GA45641@winnie.fuhr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20051229044734.GA45641@winnie.fuhr.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.053 required=5 tests=[AWL=0.053] X-Spam-Score: 0.053 X-Spam-Level: X-Archive-Number: 200512/361 X-Sequence-Number: 20081 On Wed, Dec 28, 2005 at 09:47:34PM -0700, Michael Fuhr wrote: > What are you expecting to happen and what actually does happen? Another thing: are you calling the lo_* functions within a transaction? As the Client Interfaces section of the Large Objects chapter in the documentation says, "All large object manipulation using these functions must take place within an SQL transaction block." If you call lo_open() outside a transaction block then it will fail and PQerrorMessage() will return a string like "invalid large-object descriptor: 0". -- Michael Fuhr