pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFw: lo_import problem
6+ messages / 2 participants
[nested] [flat]
* Fw: lo_import problem
@ 2006-01-19 07:10 sandhya <sandhyar@amiindia.co.in>
2006-01-19 07:30 ` Re: Fw: lo_import problem Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 1 reply; 6+ messages in thread
From: sandhya @ 2006-01-19 07:10 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fw: lo_import problem
2006-01-19 07:10 Fw: lo_import problem sandhya <sandhyar@amiindia.co.in>
@ 2006-01-19 07:30 ` Jeff Frost <jeff@frostconsultingllc.com>
2006-01-19 07:37 ` Re: Fw: lo_import problem sandhya <sandhyar@amiindia.co.in>
2006-01-19 07:38 ` Re: Fw: lo_import problem sandhya <sandhyar@amiindia.co.in>
2006-01-19 07:43 ` Re: Fw: lo_import problem Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 3 replies; 6+ messages in thread
From: Jeff Frost @ 2006-01-19 07:30 UTC (permalink / raw)
To: sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin
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@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fw: lo_import problem
2006-01-19 07:10 Fw: lo_import problem sandhya <sandhyar@amiindia.co.in>
2006-01-19 07:30 ` Re: Fw: lo_import problem Jeff Frost <jeff@frostconsultingllc.com>
@ 2006-01-19 07:37 ` sandhya <sandhyar@amiindia.co.in>
2 siblings, 0 replies; 6+ messages in thread
From: sandhya @ 2006-01-19 07:37 UTC (permalink / raw)
To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: pgsql-admin
I am trying on windows............
It is not coming.Version is 8.0
----- Original Message -----
From: "Jeff Frost" <jeff@frostconsultingllc.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:
>
> >
> >
> >
> > 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@frostconsultingllc.com>
> Frost Consulting, LLC http://www.frostconsultingllc.com/
> Phone: 650-780-7908 FAX: 650-649-1954
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fw: lo_import problem
2006-01-19 07:10 Fw: lo_import problem sandhya <sandhyar@amiindia.co.in>
2006-01-19 07:30 ` Re: Fw: lo_import problem Jeff Frost <jeff@frostconsultingllc.com>
@ 2006-01-19 07:38 ` sandhya <sandhyar@amiindia.co.in>
2 siblings, 0 replies; 6+ messages in thread
From: sandhya @ 2006-01-19 07:38 UTC (permalink / raw)
To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: pgsql-admin
I am trying on windows..I am getting the following error message.
ERROR: could not open server file
----- Original Message -----
From: "Jeff Frost" <jeff@frostconsultingllc.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:
>
> >
> >
> >
> > 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@frostconsultingllc.com>
> Frost Consulting, LLC http://www.frostconsultingllc.com/
> Phone: 650-780-7908 FAX: 650-649-1954
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fw: lo_import problem
2006-01-19 07:10 Fw: lo_import problem sandhya <sandhyar@amiindia.co.in>
2006-01-19 07:30 ` Re: Fw: lo_import problem Jeff Frost <jeff@frostconsultingllc.com>
@ 2006-01-19 07:43 ` Jeff Frost <jeff@frostconsultingllc.com>
2006-01-19 08:23 ` Re: Fw: lo_import problem sandhya <sandhyar@amiindia.co.in>
2 siblings, 1 reply; 6+ messages in thread
From: Jeff Frost @ 2006-01-19 07:43 UTC (permalink / raw)
To: sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin
This worked fine for me on a freshly installed 8.0.3 on Windows XP:
pics=# INSERT into images VALUES ( lo_import('C:\\Program 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:
>
>>
>>
>>
>> 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@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fw: lo_import problem
2006-01-19 07:10 Fw: lo_import problem sandhya <sandhyar@amiindia.co.in>
2006-01-19 07:30 ` Re: Fw: lo_import problem Jeff Frost <jeff@frostconsultingllc.com>
2006-01-19 07:43 ` Re: Fw: lo_import problem Jeff Frost <jeff@frostconsultingllc.com>
@ 2006-01-19 08:23 ` sandhya <sandhyar@amiindia.co.in>
0 siblings, 0 replies; 6+ messages in thread
From: sandhya @ 2006-01-19 08:23 UTC (permalink / raw)
To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: pgsql-admin
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@frostconsultingllc.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:\\Program
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:
> >
> >>
> >>
> >>
> >> 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@frostconsultingllc.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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-01-19 08:23 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-19 07:10 Fw: lo_import problem sandhya <sandhyar@amiindia.co.in>
2006-01-19 07:30 ` Jeff Frost <jeff@frostconsultingllc.com>
2006-01-19 07:37 ` sandhya <sandhyar@amiindia.co.in>
2006-01-19 07:38 ` sandhya <sandhyar@amiindia.co.in>
2006-01-19 07:43 ` Jeff Frost <jeff@frostconsultingllc.com>
2006-01-19 08:23 ` sandhya <sandhyar@amiindia.co.in>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox