What steps will reproduce the problem?
dbGetQuery(con,"CREATE TABLE byteatable (name text NOT NULL, val bytea, PRIMARY KEY (name))")
sample.object <- list("one","two");
ser <- serialize(sample.object,NULL,ascii=F);
df <- data.frame(name=c("first","second"),stringsAsFactors=F);
df$val <- list(ser,ser)
dbWriteTable(con,"byteatable",df,append=T,row.names=F)
What is the expected output? What do you see instead?
All this was for a bytea insertion attempt. Instead, this happens:
*** caught segfault ***
address (nil), cause 'memory not mapped'
Traceback:
1: .Call("RS_PostgreSQL_CopyInDataframe", conId, dataframe, nrow, p, PACKAGE = .PostgreSQLPkgName)
2: postgresqlCopyInDataframe(new.con, value)
3: postgresqlWriteTable(conn, name, value, ...)
4: is(object, Cl)
5: is(object, Cl)
6: .valueClassTest(standardGeneric("dbWriteTable"), "logical", "dbWriteTable")
7: dbWriteTable(con, "byteatable", df, append = T, row.names = F)
What version of the product are you using? On what operating system?
Please provide any additional information below.
1. Postgres 9.1 (don't know if matters)
> sessionInfo()
R version 2.15.3 (2013-03-01)
Platform: x86_64-pc-linux-gnu (64-bit)
locale:
[1] LC_CTYPE=en_US.UTF-8 LC_NUMERIC=C
[3] LC_TIME=en_US.UTF-8 LC_COLLATE=en_US.UTF-8
[5] LC_MONETARY=en_US.UTF-8 LC_MESSAGES=en_US.UTF-8
[7] LC_PAPER=C LC_NAME=C
[9] LC_ADDRESS=C LC_TELEPHONE=C
[11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] PKI_0.1-1 base64enc_0.1-1 RPostgreSQL_0.5 DBI_0.2-7
loaded via a namespace (and not attached):
[1] compiler_2.15.3 tools_2.15.3
Original issue reported on code.google.com by peter.kh...@gmail.com on 29 Jan 2014 at 9:41
Original issue reported on code.google.com by
peter.kh...@gmail.com
on 29 Jan 2014 at 9:41