KNOWLEDGE BASE

Unable to output to Postgres via Tableau Prep Bulder: column "inf" does not exist


Published: 27 Sep 2022
Last Modified Date: 30 Sep 2022

Issue

Tableau Prep Builder fails with the error below and flow is failing to save on to Postgres. The following error occurs

Failed to update max field size.
ERROR: column "inf" does not exist

Environment

  • Tableau Prep Builder 
  • PostgresSQL

Resolution

Find and replace the "inf" value with 0 in a column/field and re-run the output.
 

Cause

When writing the values back to the Postgres Database, the 'inf' value in the input hyper data source breaks the INSERT statement and results in an error - column "inf" does not exist.
Did this article resolve the issue?