PEDSnet / pedsnetdcc

CLI tool for PEDSnet data coordinating center ETL tasks
Other
0 stars 0 forks source link

Sync Observation Period Error #106

Closed piglet25 closed 6 years ago

piglet25 commented 6 years ago

When using Postgres 10 the following error is encountered: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression See this link for more information

piglet25 commented 6 years ago

If using Postgres 9 (9.6), use the postgres_9 branch instead of master which is compatible with Postgres 10. Since the servers will be migrated to Postgres 10 in the future the fix for Postgres 10 was merged. postgres_9 branch should not be merged.