I am trying to use the import_bytea function described in various list posts (PG version 9.3.14) in a jsp.

I get an error saying that only the super user can use server-side lo_import().

If I change the Java connection to use user postgres, the function works but I would prefer not to do this.

Is there a better way to update a bytea column from an uploaded file (in this case a small jpeg)?

Cheers and thanks,
Stephen


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to