Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sRYz3-00GWvh-6A for pgsql-general@arkaria.postgresql.org; Wed, 10 Jul 2024 15:11:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sRYz1-006K6h-Rk for pgsql-general@arkaria.postgresql.org; Wed, 10 Jul 2024 15:11:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sRYz1-006K6Y-Gn for pgsql-general@lists.postgresql.org; Wed, 10 Jul 2024 15:11:51 +0000 Received: from mail-oo1-xc30.google.com ([2607:f8b0:4864:20::c30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sRYyz-001POt-CF for pgsql-general@postgresql.org; Wed, 10 Jul 2024 15:11:50 +0000 Received: by mail-oo1-xc30.google.com with SMTP id 006d021491bc7-5c74f6e5432so775800eaf.3 for ; Wed, 10 Jul 2024 08:11:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720624307; x=1721229107; darn=postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=aibnn7JLuwELe+9nHiI7CqGJrdd9DfInb72xsca0cV8=; b=A+ktxGR9uJCCk0W/+H5CGmseYeJXII4gIsI2pWDCcRtS7VAeaYPUi4dIFnIJMDu+lQ ml48t1CQ2+y8cTSUH5JdfOlBW3ZfkgH5f8Bvz2SXRTwpWwVDHVRAvljHoCEyr2Xhs5/e xQaHAW6OZeo1GUCkL/Xd+Ci+Di53iwn9B1B8HFqGAbY3UGbxAEie741S7VFuU5Oihy++ SdiKHs5R+lP0WEyKfb6lesSmoHcwRZwfAbPLcDUqNPWN8EKsMdanIeybmrg46afF13jj 2sO/69wI7GGFUIoLBNfLFJO5ZYzXBz4CzTKJVWpd07J+YzGGn8GqIr+vm7iWXSruZ9Mh uHbA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720624307; x=1721229107; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=aibnn7JLuwELe+9nHiI7CqGJrdd9DfInb72xsca0cV8=; b=Lq7IQ8DP2D9tJAe4RzcD5cF+W7K/TMpWT/9DQ09UP8VyjDaqOHk0QcPr11xp+6E3Uk 4DMehRBecYst8tpmETckMXUZK4A+hijAwbbOWGn/gRhWKZrQ7F7FHoSujp4wn/4NYU7a 31KoMJQV26KrRaDsRaOiAxYLB5TsC2ficz4IfQnFFlAUd1e6EO7dXISSrnKH9vUa5D/O 1dtnMKrfRq8bXAtjiY6mxQ9W/XBJ3vy1vO7Vj/ru04ZSdqD/6GMrDAVOpM0xXvCm+eR7 uIOoD2Kx1Cwcmi58OyrFUTsbTx/wQFFGuc707MvSjHExfp631xZD5KMLxws/wjmj3x8M 5jNw== X-Gm-Message-State: AOJu0YzqK6ePOG0AKBhrGKNcOwe5ISzq1i2eHZzwAvt/36saDImJXdw9 37D35uuBQRKvbY0RifF5jK0r22nMO4hNkE+JjVH/nqaTdpNa8FWmUscAK2rPO6BDKsINXf5eMAh V1o45jr8uo7XcKR9N1irr1RX7sds= X-Google-Smtp-Source: AGHT+IG+m9lvL2NLacEG0sVN4q2/c68ttuSTT0zBa8oIc+AxnaDOyHbhLYx4ehPoFKVUmPlt5Vl7vjuGwGktN32me5w= X-Received: by 2002:a05:6820:3098:b0:5c7:b088:374d with SMTP id 006d021491bc7-5c7b088380amr3175979eaf.3.1720624307074; Wed, 10 Jul 2024 08:11:47 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:684f:0:b0:539:aa10:6c7 with HTTP; Wed, 10 Jul 2024 08:11:46 -0700 (PDT) In-Reply-To: <2792c01-daa9-dcf5-feb0-357d68de7158@appl-ecosys.com> References: <71cf3e97-a0a5-4a94-add8-989cd1e2311d@aklaver.com> <2792c01-daa9-dcf5-feb0-357d68de7158@appl-ecosys.com> From: "David G. Johnston" Date: Wed, 10 Jul 2024 08:11:46 -0700 Message-ID: Subject: Re: Finding error in long input file To: Rich Shepard Cc: "pgsql-general@postgresql.org" Content-Type: multipart/alternative; boundary="0000000000009d7f34061ce61044" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009d7f34061ce61044 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, July 10, 2024, Rich Shepard wrote: > On Wed, 10 Jul 2024, David G. Johnston wrote: > > And what are the first few lines of the file? Use text, not screenshots. >> > > David, > > insert into locations (company_nbr,loc_nbr,loc_name, > addr1,city,state_code,postcode) values > (2564,1,default,'4250 Hopkins Rd','Ontario','OR','97914'), > (2565,1,default,'10695 Meridian Rd','Mount Angel','OR','97362'), > (2566,1,default,'6963 Keene Rd NE','Gervais ','OR','97026'), > (2567,1,default,'31250 S Bond Rd','Hubbard','OR','97032'), > My first easy look for this setup is for any single quotes not adjacent to either a comma or a parenthesis. Syntax highlighting should ideally have caught this but I=E2=80=99d look anyway. David J. --0000000000009d7f34061ce61044 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

On Wednesday, July 10, 2024, Rich Shepard <rshepard@appl-ecosys.com> wrote:
On Wed, 10 Jul 2024, David G. Johnston wrote:

And what are the first few lines of the file? Use text, not screenshots.

David,

insert into locations (company_nbr,loc_nbr,loc_name,addr1,city,state_c= ode,postcode) values
(2564,1,default,'4250 Hopkins Rd','Ontario','OR',&#= 39;97914'),
(2565,1,default,'10695 Meridian Rd','Mount Angel','OR&#= 39;,'97362'),
(2566,1,default,'6963 Keene Rd NE','Gervais ','OR',= '97026'),
(2567,1,default,'31250 S Bond Rd','Hubbard','OR',&#= 39;97032'),

My first easy look for this setup is for a= ny single quotes not adjacent to either a comma or a parenthesis.=C2=A0 Syn= tax highlighting should ideally have caught this but I=E2=80=99d look anywa= y.

David J.
=C2=A0
--0000000000009d7f34061ce61044--