You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@streampipes.apache.org by "Tim Bossenmaier (Jira)" <ji...@apache.org> on 2021/03/16 12:46:00 UTC
[jira] [Updated] (STREAMPIPES-162) Postgres Column Names are case
sentitiv and save leads to error
[ https://issues.apache.org/jira/browse/STREAMPIPES-162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Bossenmaier updated STREAMPIPES-162:
----------------------------------------
Attachment: image-2021-03-16-13-45-32-927.png
> Postgres Column Names are case sentitiv and save leads to error
> ---------------------------------------------------------------
>
> Key: STREAMPIPES-162
> URL: https://issues.apache.org/jira/browse/STREAMPIPES-162
> Project: StreamPipes
> Issue Type: Bug
> Reporter: Florian Micklich
> Assignee: Florian Micklich
> Priority: Major
> Fix For: 0.68.0
>
> Attachments: image-2021-03-16-13-45-32-927.png
>
>
> 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:
> {code:java}
> INSERT INTO testschema.testtable ( "randomText", "randomNumber", "count", "timestamp" ) VALUES ( 'c', 69, 83531, 1591611708415 );
> {code}
> The problem here is that postgres uses lowercases for the column names.
> So instead of randomText then name has to be randomtext:
> {code:java}
> INSERT INTO testschema.testtable ( "randomtext", "randomnumber", "count", "timestamp" ) VALUES ( 'c', 69, 83531, 1591611708415 )
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)