On Sun, 1 Nov 2020, Francisco Olarte wrote:
This is nearly impossible to diagnose without a chunk of the query ( i,e, the first lines and the last ones ).
Francisco, $ psql -d bustrac -f locations.sql
It smells to missing parentheses. If you use some editor witch matches them, try adding one BEFORE the semicolon. If it matches something above you've got it.
Here're the last two lines: (2297,1,'Principal place of business','600 SE Bay Boulevard',null,'Newport','OR','97365','541-265-7758','541-265-4235',null), (2298,1,'Principal place of business','7200 NE Airport Way',null,'Portland','OR','97218',null,null,null); And psql found a few missing terminating parentheses and commas which were fixed. I expected this last run to successfully complete. Regards, Rich
