[EMAIL PROTECTED] 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

Reply via email to