org.postgresql.util.PSQLException: ERROR: syntax error

[eroell]

Hi,

trying to make the this tool run!

The following command in the README.md fails for me
ETLSyntheaBuilder::CreateSyntheaTables(connectionDetails = cd, syntheaSchema = syntheaSchema, syntheaVersion = syntheaVersion)

Running synthea_version/v320/create_synthea_tables.sql
Connecting using PostgreSQL driver
  |=================================================================================================================                       |  83%Error in `.createErrorReport()`:
! Error executing SQL:
org.postgresql.util.PSQLException: ERROR: syntax error at or near "date"
  Position: 158

For syntheaVersion=3.2.0. The same error occurs for syntheaVersion=3.3.0, with the v320 failing in the error message above. Not sure if this is an issue from my side?

Some details on my setup:

platform       aarch64-apple-darwin20      
arch           aarch64                     
os             darwin20                    
system         aarch64, darwin20           
status                                     
major          4                           
minor          4.1                         
year           2024                        
month          06                          
day            14                          
svn rev        86737                       
language       R                           
version.string R version 4.4.1 (2024-06-14)

PostgreSQL 17.2
ETLSyntheaBuilder version 2.1