Re: Importing blob

Maybe it isn't searching on the path you think it is. Try using a full path to
the file.

Regards,
    Jeff Davis

> Here is my table:
>
>  CREATE TABLE setimg (id serial, setid int8, image OID);
>
> Here is my insert:
>
>  INSERT INTO setimg(setid, image) VALUES ('32334', lo_import('32334.jpg'));
>
> And the error:
>
>  lo_import: can't open unix file "32334.jpg": no such file or directory
>
> I have tried everything that I can think of to insert this file and every
> time I get the same error.  I have set the full path to the file.  I have
> change priv to 666.  Confirmed proper ownership <user>:<user>.  And still
> it does not see it.  What am I doing wrong?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster