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]