Skip to content

RODBC problems with unixodbc

3 messages · Sébastien Bihorel, Sean Davis, Vladimir Dergachev

Original
Sébastien Bihorel
# 
Hi,

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
connection:


---<---------------cut here---------------start-------------->---
con <- odbcConnect("PostgreSQL-DB", uid="user", pwd="password",
                   case="postgresql")
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.


Cheers,
Sean Davis
#
On Tuesday 20 February 2007 13:51, Sebastian P. Luque wrote:
"end" is a reserved word in postgresql.  See here:

http://www.postgresql.org/docs/8.2/static/sql-keywords-appendix.html

This doesn't have anything to do with RODBC or unixODBC, I don't think.

Sean
Vladimir Dergachev
#
On Tuesday 20 February 2007 1:51 pm, Sebastian P. Luque wrote:
It is likely "end" is a reserved word

                     best

                         Vladimir Dergachev