[R-sig-DB] append=TRUE, overwrite=FALSE ignored in dbWriteTable

[Tomoaki NISHIYAMA]

Hi,

Can you tell the PostgreSQL driver version?

BTW,
dbWriteTable(con, "region_subgroup_mktseg", results_tograph,  append=TRUE)
should work without prior check for dbExistTable.
-- 
Tomoaki NISHIYAMA

Advanced Science Research Center,
Kanazawa University,
13-1 Takara-machi, 
Kanazawa, 920-0934, Japan


On 2011/10/27, at 7:58, Elinor Zeev wrote:

> Hello,
> Within a bigger loop, I want to write results to a table in Postgress,
> 
> the overwrite and append arguments are ignored and I end up with only the
> current data in the table and the older data is overwritten.
> My code is;
> 
> ifelse((dbExistsTable(con, "region_subgroup_mktseg")),
> dbWriteTable(con, "region_subgroup_mktseg", results_tograph,  append=TRUE,
> overwrite=FALSE),
> dbWriteTable(con, "region_subgroup_mktseg", results_tograph))
> 
> R.version
>               _
> platform       i386-pc-mingw32
> arch           i386
> os             mingw32
> system         i386, mingw32
> status
> major          2
> minor          13.2
> year           2011
> month          09
> day            30
> svn rev        57111
> language       R
> version.string R version 2.13.2 (2011-09-30)
> 
> Thank you
> 
> 	[[alternative HTML version deleted]]
> 
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>