On 11/1/20 11:04 AM, Rich Shepard wrote:
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);
Also need the beginning lines including the INSERT part.
And psql found a few missing terminating parentheses and commas which were
fixed. I expected this last run to successfully complete.
Regards,
Rich
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
