[jira] [Created] (NIFI-11465) UpdateDatabaseTable returns PostgreSQL error when there are multiple fields in Primary Key Fields property

["Patrick A. Mol (Jira)" <ji...@apache.org>]

Patrick A. Mol created NIFI-11465:
-------------------------------------

             Summary: UpdateDatabaseTable returns PostgreSQL error when there are multiple fields in Primary Key Fields property
                 Key: NIFI-11465
                 URL: https://issues.apache.org/jira/browse/NIFI-11465
             Project: Apache NiFi
          Issue Type: Bug
    Affects Versions: 1.21.0
         Environment: nifi 1.21.0 on ubuntu 20.04
            Reporter: Patrick A. Mol
         Attachments: image-2023-04-17-15-48-14-841.png, update_database_table_issue.json

When I have two fields separated by a comma in the Primary Key Fields property of UpdateDatabaseTable processor with Database Type PostgreSQL I get an error returned when running the flow (see screenprint)

!image-2023-04-17-15-48-14-841.png!


Logfile contains:
{noformat}
2023-04-17 18:45:57,792 ERROR [Timer-Driven Process Thread-1] o.a.n.p.standard.UpdateDatabaseTable [UpdateDatabaseTable[id=0187100e-5a73-1181-61bb-71e93f7fa6ff], StandardFlowFileRecord[uuid=b6df9e88-3097-4f87-bdfa-1fd5ed555de8,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1681737334979-1, container=default, section=1], offset=1583, length=132],offset=0,name=b6df9e88-3097-4f87-bdfa-1fd5ed555de8,size=132]] Exception while processing {} - routing to failure
java.io.IOException: org.postgresql.util.PSQLException: ERROR: multiple primary keys for table "my_new_three_field_table" are not allowed
  Position: 94
{noformat}

When I have one field in the Primary Key Fields property a table gets created with a unique key as expected.
When I add parentheses to the Primary Key Fields property to conform to primary key clause format, i.e. instead of 
{noformat}
field1, field2{noformat}
 use
{noformat}
 (field1, field2){noformat}
I do not get an error, and the table gets created, but without a primary key.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)