pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Large Objects - lo_export
2+ messages / 2 participants
[nested] [flat]
* Large Objects - lo_export
@ 2001-06-06 13:22 Guru Prasad <pnguruji@yahoo.com>
2001-06-06 13:04 ` Re: Large Objects - lo_export tjk@tksoft.com <tjk@tksoft.com>
0 siblings, 1 reply; 2+ messages in thread
From: Guru Prasad @ 2001-06-06 13:22 UTC (permalink / raw)
To: pgsql-sql
Hi to list !
while running psql as 'postgres' user, i executed the following query.
'select lo_export(img.image, '/home/postgres/junk.tgz') from img where
data = 'tar file';
The result of the above command is as follows.
ERROR: lo_export: can't open unix file
"/home/postgres/junk.tgz": Permission denied
i performed the above query as superuser ('postgres'). I hope it' having
all the superuser previleges.
I am not sure why i am getting the above error.
Any one got any clue for it.
thanx in advance.
guru.
bk SYSTEMS (P) Ltd.
P . N . G U R U P R A S A D
-------------------------------------------------------------------------------
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Large Objects - lo_export
2001-06-06 13:22 Large Objects - lo_export Guru Prasad <pnguruji@yahoo.com>
@ 2001-06-06 13:04 ` tjk@tksoft.com <tjk@tksoft.com>
0 siblings, 0 replies; 2+ messages in thread
From: tjk@tksoft.com @ 2001-06-06 13:04 UTC (permalink / raw)
To: pnguruji@yahoo.com; +Cc: pgsql-sql
You must be logged in as the unix user postgres.
(Presuming /home/postgres/ is writable by postgres and
the file doesn't exist.)
Try doing
touch /home/postgres/junk.tgz
from the command line. It should also fail.
Troy
>
>
> Hi to list !
>
> while running psql as 'postgres' user, i executed the following query.
>
> 'select lo_export(img.image, '/home/postgres/junk.tgz') from img where
> data = 'tar file';
>
> The result of the above command is as follows.
>
> ERROR: lo_export: can't open unix file
> "/home/postgres/junk.tgz": Permission denied
>
> i performed the above query as superuser ('postgres'). I hope it' having
> all the superuser previleges.
>
> I am not sure why i am getting the above error.
>
> Any one got any clue for it.
> thanx in advance.
>
> guru.
> bk SYSTEMS (P) Ltd.
> P . N . G U R U P R A S A D
> -------------------------------------------------------------------------------
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-06-06 13:22 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-06 13:22 Large Objects - lo_export Guru Prasad <pnguruji@yahoo.com>
2001-06-06 13:04 ` tjk@tksoft.com <tjk@tksoft.com>
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