Re: Another user error?

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@aklaver.com