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 1sKIyV-009PLy-3d for pgsql-general@arkaria.postgresql.org; Thu, 20 Jun 2024 14:41:19 +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 1sKIyR-008ohS-Md for pgsql-general@arkaria.postgresql.org; Thu, 20 Jun 2024 14:41:16 +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 1sKIyR-008oh2-BL for pgsql-general@lists.postgresql.org; Thu, 20 Jun 2024 14:41:16 +0000 Received: from mail-pl1-x632.google.com ([2607:f8b0:4864:20::632]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sKIyP-002GZS-Qi for pgsql-general@lists.postgresql.org; Thu, 20 Jun 2024 14:41:15 +0000 Received: by mail-pl1-x632.google.com with SMTP id d9443c01a7336-1f6b0a40721so7290885ad.2 for ; Thu, 20 Jun 2024 07:41:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718894472; x=1719499272; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=SCuud0586mq0b7WXGJQpW5UkAXxpPnRks+FImFHa4js=; b=a9Z5eHPmVJLwTBWHoXfzEWg0Bh0AAHu2rZYQjq6YHM+4g/XoIsGtzx5OKHdjYZqUus t4pn3OcL6PrsY0jfvaYDzvN8O7l8mIZZBo2TMTPOqoh4+X5c9AiCv98r6GyUV+IE3Ns/ wkfdq8HFWm3KGu3UmigAG/0CT+ADE96oz55u31Ft2YQaA965bPujwEPgulufaEyGMLaz fOyCtsj9lO8Ii8LHQy5nc4mEKq6s7HU4Sg6LC/gFzMhn0qrWeslOrLjSYSj9XtPwJ0YB AZGuv9c6SFBJN5DqjeUMKYhsfPTGCg9tVB8SNVCAtaiupQz/C73/7GmorScsYxmFWJ/k Rt4A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718894472; x=1719499272; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=SCuud0586mq0b7WXGJQpW5UkAXxpPnRks+FImFHa4js=; b=gi/eSp53U1fNOoeBulPxOmvqYnTF/hSxqpt4h3GMotB8lNMAk9+esv3EkoAV7rIJE9 pEL4g/+F3wZWMXR985cDlkK/IrcYZlPxSdLuRshgZFdwSKz28ycvJJZPkpk0l9rBhfzV NTFlmzSbf0sEwz249eJ+XcpghHm9BEPBqNCydvXHFFzm+XM/Y7u6hz9vOB++FponparC hT+iK7mYgOe+T94Cfgv2Fi/zU84UfJv4yrC2OKlKHkqBAZd3hVCcLNg5+XjWL1VnKUHQ Xj2dCAqyM/65fSzEVK9hSSkirEaTX1GyCBf+1tpRj5sc3cSo4UWonCYZtfEdaIDVtEkE UXZQ== X-Gm-Message-State: AOJu0YzkoBeLcwbFtqPkHrRd8LrwZglTiWBCG6EIRvhqecX7fcUTQ2Ea 9l434ipf9DpNPTXAXzXll9l5q4kyd1mYDjUN+RgE5TIVREdQlP/9LpDz/Q== X-Google-Smtp-Source: AGHT+IHCrkfhpQcY5TeL3/AdISjiFcII+w83rLwh22oUZoTvzBpr4IqLbnCOfXNahbKjLedI+vMtzA== X-Received: by 2002:a17:903:1cf:b0:1f8:90df:7437 with SMTP id d9443c01a7336-1f9aa411e14mr60557325ad.38.1718894472252; Thu, 20 Jun 2024 07:41:12 -0700 (PDT) Received: from smtpclient.apple ([2601:681:5a00:f790:bd51:a9d0:ecee:671b]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-1f855efea73sm137471935ad.182.2024.06.20.07.41.11 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 20 Jun 2024 07:41:11 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Transaction issue Date: Thu, 20 Jun 2024 08:41:00 -0600 Message-Id: <393A432B-E08C-46C6-B8FE-BE20BEE4E122@gmail.com> References: <55a3c9-5baa-ba24-c3fb-c9a777b7917e@appl-ecosys.com> Cc: pgsql-general@lists.postgresql.org, pgsql-general@postgresql.org In-Reply-To: <55a3c9-5baa-ba24-c3fb-c9a777b7917e@appl-ecosys.com> To: Rich Shepard X-Mailer: iPhone Mail (21F90) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jun 20, 2024, at 7:05=E2=80=AFAM, Rich Shepard wrote: >=20 > =EF=BB=BFOn Thu, 20 Jun 2024, Karsten Hilbert wrote: >=20 >> Shot in the dark: are you be any chance using tab-completion >> when running the SELECT before the COMMIT ? >=20 > Karsten, >=20 > Nope. I prepare DDL, DML, and DQL scripts in emacs, then run them from the= > psql prompt using \i . >=20 Is psql running in emacs (which is my preferred sql shell. M-x sql-postgres)= ? Also change all semi-colons to \p\g to confirm the error location. Maybe tr= ap the output > Regards, >=20 > Rich >=20 >=20