jbduffy@xxxxxxxxxxxxx writes:
> However, when I run the function within psql, still as the postgres superuser,
> I get a 'permission denied' response to the perl 'open(DATA, "my_csv_file")
> within my 'import()' function.
>
> The csv file is world readable as I have moved it to /tmp and given the world
> 'rwx' permissions.
Is this Redhat? They apparently configure SELinux to disallow
Postgres access to files outside of /var/lib/pgsql/data.
-Doug
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
