This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
That's great to hear that the PostgreSQL Bulk works for you on Designer 2020.3. The issue most likely is that Alteryx Server 2019.1 does not recognize the "pgbi" format in the connection string because it didn't exist prior to 2020.3. It's best practice to keep all Designer clients to match Alteryx Server if publishing workflows to Gallery to avoid compatibility issues.
As mentioned, the PostgreSQL Bulk feature is new to 2020.3 and higher and it will not work on any Designer or Server version prior.
If you plan to re-run the bulk many times, I'd recommend using the "Delete Data & Append" option instead of the Overwrite table option. The drop table option completely destroys the table structure including the data and starts over, while the Delete Data option only removes\truncates rows of data within a table but keeps the table structure in-tact.
It's recommended to consult your DBA to help with the constraints issue and investigate further.