Skip to main content

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

  • June 3, 2021
  • 1 reply
  • 279 views

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).

Did this topic help you find an answer to your question?

1 reply

Forum|alt.badge.img+9
  • Zapier Staff
  • 238 replies
  • June 4, 2021

Hey @skirkpatrick!

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