Re: Another user error?

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