On 9 Apr 2015, at 6:04pm, Gustav Melno <knarks at online.de> wrote: > Thanks for the help. Adding a trailing underscore helped also. I'm still > wondering why insertion worked at all because defining oid as column name > with the type VARCHAR should result in an error on execution.
The three names for the integer primary key column (oid, rowid, _rowid_) work only if the table doesn't have a defined column of that name. This allows compatibility with people who didn't know that they were had special meanings for SQLite. Clever, isn't it ? Simon.
