[R] RSQLite column names underscores

[Christopher Bare]

Hi,

When I use RSQLite's dbWriteTable(...) function, the columns in the db
table frequently end up having "__1" (two underscores and a one) added
to them. The names are unique within the table and contain no weird
characters. For example a "position" column from a data.frame was
written to the DB as "position__1".

Does anyone understand how this name munging happens and how I can
prevent or work around it? Having these suffixes added seemingly
arbitrarily makes it hard to construct the next query.

Thanks for any hints,

-chris