Support Article
Database Type Error on PostgreSQL DATE data type
SA-38898
Summary
When attempting to save a date property, a SQL (pyCommit) error is returned.
There is an explanation that there is a problem with an unknown database data type of "DATE" in the database.
Error Messages
pyCommit error
Steps to Reproduce
Not Applicable
Root Cause
The Pega date property maps to a varchar(8) in PostgreSQL.
The PostgreSQL data type DATE is not directly supported.
Resolution
Alter the table to have the date column defined as varchar(8).
Published August 26, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.