Issue 75 in rpostgresql: dbWriteTable incompatible with non-default schemas

[rpost...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 75 by seth.f...@disneyresearch.com: dbWriteTable incompatible
with non-default schemas
https://code.google.com/p/rpostgresql/issues/detail?id=75

> What steps will reproduce the problem?

library(RPostgreSQL)
con <- dbConnect(XXXyourPostgreSQLsettingsXXX)

dbGetQuery(con, 'CREATE SCHEMA t1;')
dbWriteTable(con, 't1.test1', as.data.table(c(2)), append=T, row.names=F)
dbGetQuery(con, 'SELECT * FROM t1.test1;')
dbGetQuery(con, 'SELECT * FROM public."t1.test1";')

First select query shouldn't throw and error, and the second one should.
You probably know about this problem (a known bug is referenced in the "SET
search_path" workaround described here:
http://stackoverflow.com/questions/10032390/writing-to-specific-schemas-with-rpostgresql
) but I thought I'd post it anyways.

Versions:
OS X 10.10.2
R 3.1.2
PostgreSQL 9.3.4.1 (23)
RPostgreSQL 0.4
DBI 0.3.1


--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

[rpost...@googlecode.com]

Comment #1 on issue 75 by seth.f...@disneyresearch.com: dbWriteTable

incompatible with non-default schemas
https://code.google.com/p/rpostgresql/issues/detail?id=75

Oh, and doing the CREATE TABLE through dbGetQuery works fine. It's only
dbWriteTable that fails to recognize the period as a schema delimiter.