Re: reading reading files from the DB - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: reading reading files from the DB
Date
Msg-id 20051229074442.GA46583@winnie.fuhr.org
Whole thread Raw
In response to Re: reading reading files from the DB  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Gourish Singbal
Date:
Subject: Re: migrating oracle table to PostgresQL
Next
From: Mohamed Fazil
Date:
Subject: Req Documentation for installing PG SQL8.1 by hand