dominikriemer opened a new issue, #357:
URL: https://github.com/apache/streampipes/issues/357

   Usinfg the Randomdata-Adapter with a Postgres Sink:
   
   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 )
   
   ```
   
   
   
   Imported from Jira 
[STREAMPIPES-162](https://issues.apache.org/jira/browse/STREAMPIPES-162). 
Original Jira may contain additional context.
   Reported by: micklich.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to