[jira] [Commented] (STREAMPIPES-278) Error on pipeline postgres - relation already exists

["Tim Bossenmaier (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/STREAMPIPES-278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17302527#comment-17302527 ] 

Tim Bossenmaier commented on STREAMPIPES-278:
---------------------------------------------

Hi [~dvitorino],

I just tried to reproduce your error by writing values from the Random Data Adapter to an existing table using the Postgresql sink. However, it worked for me without error. 
Do you still have the problem? If so, can you tell me a bit more about your setup and when the error occurs? What pipeline elements are you using? Did you create the table by hand or was it created by StreamPipes before?

Best
Tim

> Error on pipeline postgres - relation already exists
> ----------------------------------------------------
>
>                 Key: STREAMPIPES-278
>                 URL: https://issues.apache.org/jira/browse/STREAMPIPES-278
>             Project: StreamPipes
>          Issue Type: Bug
>          Components: Pipeline Elements
>    Affects Versions: 0.67.0
>            Reporter: Daniel Vitorino
>            Assignee: Tim Bossenmaier
>            Priority: Major
>              Labels: postgres, postgresql
>
> Hi.
> There is an error on postgres module. 
> This message happens after I start the pipeline.
> The table already exists, but streampipes instead of update it with the data, try to create the table again.
>  
> _"14:16:27.178 SP [Thread-9] ERROR o.a.s.s.d.jvm.postgresql.PostgreSql - USERLOG - correspondingPipeline: ed13463d-01e9-4ab5-94fa-cc66791f6e33 - peURI: http://pipeline-elements-all-jvm:8090/sec/org.apache.streampipes.sinks.databases.jvm.postgresql/ed13463d-01e9-4ab5-94fa-cc66791f6e33-org.apache.streampipes.jIIFQqIanChHGIsXtAts-postgresql-3 - ERROR: relation "secagem_toggling" already exists"_



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