Reputation: 2611
I'm using citus columnar extension cstore_fdw for PostgreSQL (I'm on 9.4.1).
I create the foreign table without any problem.
The problem starts in R when I try to write into it.
A normal dbWriteTable
command does not work:
cba <- dbWriteTable(conpg, name=dataDt1_, value=df, row.names=FALSE, overwrite=TRUE)
Error in (function (classes, fdef, mtable) :
unable to find an inherited method for function ‘dbWriteTable’ for signature ‘"PostgreSQLConnection", "db.table", "data.frame"’
Considering that for PostgreSQL a foreign table can be a csv, a table on another server, a columnar store etc., does anybody have experience accessing any of the above with R?
Upvotes: 2
Views: 336
Reputation: 886
cstore_fdw doesn't support UPDATE
and DELETE
. version 1.2 added support for INSERT INTO cstore_table SELECT ...
, but the support for single row inserts is still missing.
Currently you can append data to a cstore table in one of the following ways:
COPY
commandINSERT INTO cstore_table SELECT ...
Upvotes: 2