Skip site navigation (1) Skip section navigation (2)

Can't read input file

From: "Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Can't read input file
Date: 2003-01-24 15:13:50
Message-ID: OF13179414.57EC9D6F-ON86256CB8.005321B7@ipaper.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I am trying to load a table by using the COPY command.  I am running the 
perl script my self and the data is located in the same directory as the 
perl script.  However, I get the following error:

ERROR:  COPY command, running in backend with effective uid 501, could not 
open file 
'/data/db/db_scripts/counterpoint/contract_IMCODF_SUB_CAT_output' for 
reading.  Errno = Permission denied (13).

This output file is created by the perl script and has the following 
permissions:

-rw-rw-r--    1 drajput  drajput      8934 Jan 24 09:00 
contract_IMCODF_SUB_CAT_output

Any ideas on what is happening.  Thanks,

Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474

Responses

pgsql-novice by date

Next:From: Desmond CoughlanDate: 2003-01-24 16:45:37
Subject: Re: Can't read input file
Previous:From: Rebecca.R.HepperDate: 2003-01-24 15:10:31
Subject: Starting postgresql server in RedHat 8.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group