could not open server file

Started by beulah prasanthiabout 16 years ago3 messagesbugs
Jump to latest
#1beulah prasanthi
itsbeulah@gmail.com

Helo
I am beulah i am using postgres 8.4 in my java project using jdk6
i created a table image and i gave datatype for image is oid
and i want to import my image from client i gave like
INSERT INTO image
VALUES(1,'fruit', (lo_import('C:\\My Pictures\\sample.jpg')));

Error : could not open server file C:\\My Pictures\\sample.jpg No such file
or directory
can u help me please

#2Kevin Grittner
Kevin.Grittner@wicourts.gov
In reply to: beulah prasanthi (#1)
Re: could not open server file

beulah prasanthi wrote:

This is very unlikely to be a PostgreSQL bug. Another list would
have been more appropriate.

Error : could not open server file C:\\My Pictures\\sample.jpg
No such file or directory

Anyway, do you have standard_conforming_strings turned on?

-Kevin

#3Robert Haas
robertmhaas@gmail.com
In reply to: Kevin Grittner (#2)
Re: could not open server file

On Sun, Jan 10, 2010 at 10:22 AM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:

Error : could not open server file C:\\My Pictures\\sample.jpg
No such file or directory

Anyway, do you have standard_conforming_strings turned on?

Good question. Another thought would be whether the OP is perhaps
confusing the client and server filesystems.

...Robert