From: | "Steve Kirby" <sfkirby(at)arl(dot)army(dot)mil> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | |
Date: | 2002-06-13 17:04:23 |
Message-ID: | OFDBA7CD55.FE5C3F28-ON87256BD7.005C37CC@arl.army.mil |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
This is a follow-up to something I asked about last night. As I said, this is the error below - I am trying to do a lo_import through JSP and
get this error:
ERROR: You must have Postgres superuser privilege to use server-side
lo_import(). Anyone can use the client-side lo_import() provided by libpq.
From Bruce Momjian's book I find this:
Because large objects use the local filesystem, users connecting over a network cannot use lo_import or lo_export().
They can, however, use psql's \lo_import and \lo_export commands.
It is hard to see how to use psql's \lo_import via JSP.
So my question is: if I want to store a blob like a jpeg in a postgresql database, are there any alternatives to lo_import? TIA
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2002-06-13 17:10:46 | Re: |
Previous Message | Paul Bethe | 2002-06-13 16:11:47 | New Patch For CallableStmt (against current CVS) |