[R-sig-DB] dbWriteTable permission problem on Mac OSX

[Whit Armstrong]

postgresqlWriteTable serializes your entire table to disk, and then
asks postgres to read it back.

It looks like the user name running postgres isn't able to read your file.

I'm sure someone on this list will help you solve your permission
issues.  In case they can't you can try my postgres driver (which
writes via binary transfer though the connection).

http://github.com/armstrtw/unifieddbi

-Whit


On Tue, Nov 3, 2009 at 4:35 PM, McGehee, Robert
<Robert.McGehee using geodecapital.com> wrote:
> R-Sig-DB,
> I'm getting a 'Permission denied' error when trying to use the
> 'dbWriteTable' function (RPostgreSQL\DBI package) to access PostgreSQL
> on my Mac OSX. I saw that this error appears to have been documented in
> the README file as affecting versions of Linux running SELinux. However,
> since my OSX Server is not running SELinux, I wanted to see if anyone
> else has had success using 'dbWriteTable' on a Mac with RPostgreSQL.
>
> I can update a database using INSERT commands, but am looking for a
> faster solution. Also RODBC crashes my R session when executing the
> 'sqlTables' function--presumably due to an ODBC driver problem--so
> switching packages won't easily help.
>
> Thanks, Robert
>
> ---------------------
>> dbWriteTable(pcon, "test", data)
> Error in postgresqlExecStatement(conn, statement, ...) :
>  RS-DBI driver: (could not Retrieve the result : ERROR:  could not open
> file "/tmp/RtmprNh2yy/rsdbi60b7acd9" for reading: Permission denied
> )
> Warning in postgresqlWriteTable(conn, name, value, ...) :
>  could not load data into table
> [1] FALSE
>
>
>> R.version
>               _
> platform       x86_64-apple-darwin9.5.0
> arch           x86_64
> os             darwin9.5.0
> system         x86_64, darwin9.5.0
> status
> major          2
> minor          9.0
> year           2009
> month          04
> day            17
> svn rev        48333
> language       R
>
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>