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 1ubOiL-000K9m-7c for pgsql-general@arkaria.postgresql.org; Mon, 14 Jul 2025 19:19:49 +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 1ubOiI-00CKU8-Vr for pgsql-general@arkaria.postgresql.org; Mon, 14 Jul 2025 19:19:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ubOiI-00CKTv-L9 for pgsql-general@lists.postgresql.org; Mon, 14 Jul 2025 19:19:47 +0000 Received: from mail.appl-ecosys.com ([50.126.108.78]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1ubOiH-007Hge-1F for pgsql-general@lists.postgresql.org; Mon, 14 Jul 2025 19:19:46 +0000 Received: from salmo.appl-ecosys.com (salmo.appl-ecosys.com [192.168.55.1]) by mail.appl-ecosys.com (Postfix) with ESMTP id 3F4D32A14D6 for ; Mon, 14 Jul 2025 12:19:44 -0700 (PDT) Date: Mon, 14 Jul 2025 12:19:44 -0700 (PDT) From: Rich Shepard To: pgsql-general@lists.postgresql.org Subject: Re: Syntax error needs explanation [RESOLVED] In-Reply-To: Message-ID: <9c62a6d5-14a-802-b869-6386d7e050fb@appl-ecosys.com> References: <9c84776d-d938-9fa4-ab1-6ee960ce6e7d@appl-ecosys.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 14 Jul 2025, David G. Johnston wrote: > The error indicates your script file is at least 127 lines long and you > are showing like 9...also do you usually name your script files with a > .txt extension? David J., Agh! No the filename extension is .sql. But I was using the \o psql option to write script output to files and mistyped the script name. Mea culpa! Many thanks, Rich