pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: 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