Feedback-ID: i76984098:Fastmail
Message-ID: <155fc2ec-d936-4838-b4dd-ca7d06acb6a1@aklaver.com>
Date: Tue, 9 Jul 2024 21:58:07 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Finding error in long input file
To: Craig McIlwee <craigm@vt.edu>
Cc: Rich Shepard <rshepard@appl-ecosys.com>, pgsql-general@postgresql.org
References: <b9639830-1a9-c1fc-8444-a436b167c56c@appl-ecosys.com>
 <71cf3e97-a0a5-4a94-add8-989cd1e2311d@aklaver.com>
 <fe393542-b125-de58-6333-623ab86dbafe@appl-ecosys.com>
 <a7fa574d-f32f-4c90-8ab2-51fec0448d89@aklaver.com>
 <CAGqBcTavtJS36PnuYs1yHHH2f6kM79NVhKiOcnn5orYNXJawxQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAGqBcTavtJS36PnuYs1yHHH2f6kM79NVhKiOcnn5orYNXJawxQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/155fc2ec-d936-4838-b4dd-ca7d06acb6a1%40aklaver.com>
Precedence: bulk

On 7/9/24 17:46, Craig McIlwee wrote:
> Full error message from earlier in the thread:
> 
>  > psql:scripts/insert-addrs.sql:488: ERROR:  syntax error at or near ";"
>  > LINE 488: ...2832,1,default,'85250 Red House Rd','Paisley','OR','97636');
>  >                                                                      
>      ^
> 
> 
>     The error:
> 
>     LINE 488: ...2832,1,default,'85250 Red House Rd','Paisley','OR','97636')
> 
>     is giving you the line number and the data:
>     a) Navigate to that line number using whatever method Joe has for that.
>     b) Search for '85250 Red House Rd'.
> 
> 
> 
> The input file is 488 lines (presumably, since Rich said the file should 
> insert 488 rows).  It seems like too much of a coincidence that the last 
> character of the last line is really the error.  My guess is that there 

This assumes that there where only INSERT lines and that each INSERT was 
only one line. I have bit by those assumptions before, hence my 
suggestion to actually find line 488.

> is an unmatched character, perhaps a parenthesis, that is throwing off 
> the parser because it doesn't expect the statement to terminate yet.  
> Maybe that unmatched char really is on the last line, but '85250 Red 
> House Rd' doesn't seem like the issue.  I don't know anything about the 
> joe editor, but I'd hope that any decent editor with syntax highlighting 
> would make it apparent where things went awry.
> 
> Craig

-- 
Adrian Klaver
adrian.klaver@aklaver.com