[Rd] RODBC problems with unixodbc

Sebastian P. Luque spluque at gmail.com
Tue Feb 20 19:51:45 CET 2007


I noticed that if a column is named "end" in a data frame (table.df
below), it leads to errors when trying to sqlSave()'it to a postgresql

---<---------------cut here---------------start-------------->---
con <- odbcConnect("PostgreSQL-DB", uid="user", pwd="password",
R> sqlSave(con, table.df)
Error in sqlSave(con, table.df) : 
	[RODBC] ERROR: Could not SQLExecDirect
42601 7 [unixODBC]Error while executing the query;
ERROR:  syntax error at or near "end" at character 140
---<---------------cut here---------------end---------------->---

If I rename the column to something else (e.g. "ending"), this proceeds
without problems.  What could the problem be here?  Thanks.



More information about the R-devel mailing list