PostgreSQL Errors for column type "money" - We're having trouble loading 'Primary Key' data

  • 3 June 2021
  • 1 reply

We recently added a column to a PostgreSQL table using the money datatype.  This caused our Zaps to stop working and “We’re having trouble …” messages that also state “(Can’t generate DDL for NullType(); did you forget to specify a type on this Column?)” but not the column name.

Problem solved by changing the properties of the Columns from Data type “money” to Data type “numeric” (without specifying any Length/Precision).

1 reply

Userlevel 4
Badge +9

Hey @skirkpatrick!

Thanks for sharing the tip with the Community 😀 Happy Zapping!