[jira] [Created] (STREAMPIPES-162) Postgres Column Names are case sentitiv

["Florian Micklich (Jira)" <ji...@apache.org>]

Florian Micklich created STREAMPIPES-162:
--------------------------------------------

             Summary: Postgres Column Names are case sentitiv
                 Key: STREAMPIPES-162
                 URL: https://issues.apache.org/jira/browse/STREAMPIPES-162
             Project: StreamPipes
          Issue Type: Bug
            Reporter: Florian Micklich
            Assignee: Florian Micklich
             Fix For: 0.67.0


The database, schema and table is created as expected but during save in the Postgres Sink


but during save I get all the time:

 Table 'testtable' was unexpectedly not found and gets recreated.
 ERROR: column "randomText" of relation "testtable" does not exist

So the first message is a little bit misleading, because the table
exists but can't be found and will be recreated in an endless loop.

The reason is because this statement during the
generatePreparedStatement method:

	INSERT INTO testschema.testtable ( "randomText", "randomNumber", "count", "timestamp" ) VALUES ( 'c', 69, 83531, 1591611708415 );


The problem here is that postgres uses lowercases for the column names.
So instead of randomText then name has to be randomtext:

	INSERT INTO testschema.testtable ( "randomtext", "randomnumber", "count", "timestamp" ) VALUES ( 'c', 69, 83531, 1591611708415 )



--
This message was sent by Atlassian Jira
(v8.3.4#803005)