From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Another user error? |
Date: | 2020-11-01 19:10:00 |
Message-ID: | cabaddc8-343a-ad80-b5ee-0e19fa176134@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2020-11-01 19:13:22 | Re: Another user error? |
Previous Message | Rich Shepard | 2020-11-01 19:04:27 | Re: Another user error? |