lo_export

PostGreSQL 7.4.5 (RedHat 8)

We have images stored in the database, that our application allows the
user to export (using lo_export), update, and then reimport. How do I
get around the permissions issue?
The user connects to the database as, say, 'user1' - this is fine. The
lo_export (server command) exports as postgres::users with permissions
of 644. User1, cannot then edit the image, as they do not have
permission.

Is there a way of changing postgres's (lo_export's?) default umask? I
have tried changing it in /etc/profile (targetted at postgres LOGNAME) -
in the .bash_profile for postgres, and also in pg_ctl (for the start up)
- but I can't appear to change it. So presumably, there's another way of
doing this?

PS I've also tried setting the target directory as g+s - that's ok to
the point that the file is then created with the group of the directory
- but obviously still not correct permissions to edit the file.

Regards,

Steve Tucknott

ReTSol Ltd

DDI: 01903 828769