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



Reply via email to