PostgreSQL Administration - Fw: lo

Author

Fw: lo_import problem

sandhya

2006-01-19, 3:24 am

When i am using lo_import to load files into the database i am getting the following error.....
Please help me what i need to do

Insert into sampletbl values(lo_import('c:
\\sample.txt'),'sample.txt');

ERROR: function lo_import ("unknown") does not exist
HINT: No function matches the given name and argument types. You may need to ad
d explicit type casts.

Jeff Frost

2006-01-19, 3:24 am

This is what works for me from the command line on Linux with PG 8.0.3:

INSERT into images VALUES ( lo_import('/tmp/white.jpg'), 'white');

What version of postgresql are you using?

On Thu, 19 Jan 2006, sandhya wrote:

>
>
>
> When i am using lo_import to load files into the database i am getting the following error.....
> Please help me what i need to do
>
> Insert into sampletbl values(lo_import('c:
\\sample.txt'),'sample.txt');
>
> ERROR: function lo_import ("unknown") does not exist
> HINT: No function matches the given name and argument types. You may need to ad
> d explicit type casts.

--
Jeff Frost, Owner < jeff@frostconsulting
llc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

sandhya

2006-01-19, 3:24 am

I am trying on windows............
It is not coming.Version is 8.0

----- Original Message -----
From: "Jeff Frost" < jeff@frostconsulting
llc.com>
To: "sandhya" <sandhyar@amiindia.co.in>
Cc: "Postgres" <pgsql-admin@postgresql.org>
Sent: Thursday, January 19, 2006 1:00 PM
Subject: Re: [ADMIN] Fw: lo_import problem

> This is what works for me from the command line on Linux with PG 8.0.3:
>
> INSERT into images VALUES ( lo_import('/tmp/white.jpg'), 'white');
>
> What version of postgresql are you using?
>
> On Thu, 19 Jan 2006, sandhya wrote:
>
the following error.....[color=darkred]
need to ad[color=darkred]
>
> --
> Jeff Frost, Owner < jeff@frostconsulting
llc.com>
> Frost Consulting, LLC http://www.frostconsultingllc.com/
> Phone: 650-780-7908 FAX: 650-649-1954
>

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

sandhya

2006-01-19, 3:24 am

I am trying on windows..I am getting the following error message.
ERROR: could not open server file

----- Original Message -----
From: "Jeff Frost" < jeff@frostconsulting
llc.com>
To: "sandhya" <sandhyar@amiindia.co.in>
Cc: "Postgres" <pgsql-admin@postgresql.org>
Sent: Thursday, January 19, 2006 1:00 PM
Subject: Re: [ADMIN] Fw: lo_import problem

> This is what works for me from the command line on Linux with PG 8.0.3:
>
> INSERT into images VALUES ( lo_import('/tmp/white.jpg'), 'white');
>
> What version of postgresql are you using?
>
> On Thu, 19 Jan 2006, sandhya wrote:
>
the following error.....[color=darkred]
need to ad[color=darkred]
>
> --
> Jeff Frost, Owner < jeff@frostconsulting
llc.com>
> Frost Consulting, LLC http://www.frostconsultingllc.com/
> Phone: 650-780-7908 FAX: 650-649-1954
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Jeff Frost

2006-01-19, 3:24 am

This worked fine for me on a freshly installed 8.0.3 on Windows XP:

pics=# INSERT into images VALUES ( lo_import('C:\\Progr
am Files\\PostgreSQL\\8
.0\\Installation Notes.rtf'), 'notes');

"could not open server file" means that either the file does not exist, or the
user you are trying to access the file as does not have the rights to read it.

Again, check your permissions as I mentioned to you earlier.

On Wed, 18 Jan 2006, Jeff Frost wrote:

> This is what works for me from the command line on Linux with PG 8.0.3:
>
> INSERT into images VALUES ( lo_import('/tmp/white.jpg'), 'white');
>
> What version of postgresql are you using?
>
> On Thu, 19 Jan 2006, sandhya wrote:
>
>
>

--
Jeff Frost, Owner < jeff@frostconsulting
llc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

sandhya

2006-01-19, 3:24 am

ok...jeff thank you very much.
I checked in pg_hba.conf and reloaded again and did now working fine.

----- Original Message -----
From: "Jeff Frost" < jeff@frostconsulting
llc.com>
To: "sandhya" <sandhyar@amiindia.co.in>
Cc: "Postgres" <pgsql-admin@postgresql.org>
Sent: Thursday, January 19, 2006 1:13 PM
Subject: Re: [ADMIN] Fw: lo_import problem

> This worked fine for me on a freshly installed 8.0.3 on Windows XP:
>
> pics=# INSERT into images VALUES ( lo_import('C:\\Progr
am
Files\\PostgreSQL\\8
.0\\Installation Notes.rtf'), 'notes');
>
> "could not open server file" means that either the file does not exist, or
the
> user you are trying to access the file as does not have the rights to read
it.
>
> Again, check your permissions as I mentioned to you earlier.
>
> On Wed, 18 Jan 2006, Jeff Frost wrote:
>
the[color=darkred]
need[color=darkred]
>
> --
> Jeff Frost, Owner < jeff@frostconsulting
llc.com>
> Frost Consulting, LLC http://www.frostconsultingllc.com/
> Phone: 650-780-7908 FAX: 650-649-1954
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links