Re: [postgres] Insert and Update execution fails if table column name contains Upper case

2018-11-02 Thread Kasper Sørensen
I don't have much insight. One thought though: Are you doing these inserts/updates with the same DataContext that you used for creating the table? Or was the table pre-existing? I'm asking because I guess it could be related to the CREATE TABLE which defined the column names too. And if MetaModel

Re: [postgres] Insert and Update execution fails if table column name contains Upper case

2018-11-02 Thread Dennis Krøger
According to https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS, columns are case-insensitive if created without quotes, but case-sensitive if created with quotes. I'm not entirely sure how we're handling that. It's not really a difference the table

[postgres] Insert and Update execution fails if table column name contains Upper case

2018-11-02 Thread Vijay Kumar Jalagari
Hi, I am using Apache metamodel with data source PostgreSQL 11 and while executing insert(InsertInto) or update statement query is failing if table column name contains upper characters. According to logs statement is generating properly but it seems postgresql is converting column names to