| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | sandhya <sandhyar(at)amiindia(dot)co(dot)in> |
| Cc: | postgre <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: reading reading files from the DB |
| Date: | 2005-12-29 07:44:42 |
| Message-ID: | 20051229074442.GA46583@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mohamed Fazil | 2005-12-29 11:29:49 | Req Documentation for installing PG SQL8.1 by hand |
| Previous Message | Gourish Singbal | 2005-12-29 06:16:51 | Re: migrating oracle table to PostgresQL |