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 1sK3HG-0084hL-AY for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 21:55:38 +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 1sK3HD-008IO6-Rt for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 21:55:36 +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 1sK3HD-008IMN-Gz for pgsql-general@lists.postgresql.org; Wed, 19 Jun 2024 21:55:36 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sK3HB-002921-Ts for pgsql-general@postgresql.org; Wed, 19 Jun 2024 21:55:35 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-5bfa5f9bbe6so99138eaf.3 for ; Wed, 19 Jun 2024 14:55:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718834133; x=1719438933; 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=WCj3oHJ7SuolmfWuKIhP7tNF//mC6Hmb81tZ0tWkDjE=; b=kLa22OX0yFjk1GoENGwp6fMwv2/lzfkXhdZxUjwSqrLx+sK8pDX4ymrjIw70XqL68e z83BDyEvP3O75+stlDVFxaqrzzuRP3KNiWVu95ZCqzhoWRZHXDRyQtyt1UT4IbN//hoJ jfbRXbscc0EuwzYgj5TBJKEMCN1Jnuqa/ubinvMclbOv+q7DeDT31SN5S05nVo916ipx K3Nn3Za5VOCURrKaLYbREkRbs0YvIwnK4u9h6KzgEmX2HkaRapBTIaomUOGR+KVnru4v o7wusKKS0Pw42ZEunwWDKroGPkXfu1qW6LlOB/GBNyKOhZNwgRlCIJKKUCKtmvbpZeG5 ZcgA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718834133; x=1719438933; 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=WCj3oHJ7SuolmfWuKIhP7tNF//mC6Hmb81tZ0tWkDjE=; b=DMN6zNA+7sq7gSgG8ntRldVf0GdYc7T+md+gUwGT7xRpEsss5429UUAqcXv64FWGxR expHupEJqQyk8YHPykvcIHUwScrWgFUl4NFpulhda+Snruja6tCwWke6wntNeWM14/PW qr7smLXhO1AaFMnc7w4MFzzwPiiSLO4yp/1OjwwhlrFZFL4KUquJfv2HOjHzN6sUTeWv oHgKmyHZKbK9LhAcctJ5f/o4t7tLwxdF4sY7sKRSONR8Aulgl9g7CAnLBODdB5y2hWnY PupcPbsQBfhxS1byO0cyRAb2aZY23SitU/HPu1a7rYcxNIxNqOxCpb18OaUh9IlNtBF9 lZHg== X-Forwarded-Encrypted: i=1; AJvYcCWXkfe8js5gjyE/dSNQqcNytMqVUIpbNunlJuJ6lSfwXUYdkMEE5uGe2xMXmSJtCxwD/zidrrvEdTpqa5KCCb9uLwPG/7FVzklkjlQo X-Gm-Message-State: AOJu0YzfxcjJXXWI/LVvVoOLp68edMzbfFm6eeIvAEPsubA7PXe8Kcts J7BizZpTO2j5pf9PJQpFtY7KPmTg0gEjowjMSbbNGcnRMPkGcjvaWRzTEQwuOEmqJqhmopt1Lg8 ECIT6TQrR4nGFzV5JAHXxX64we7U= X-Google-Smtp-Source: AGHT+IHdlssaG/+Ssf4igwtFUHDw6rzHjexCFsqtJcaVCXdRdNJ5MW1IXk6PZrRyhCEXk81eB4k8D5JsLEJE+5vVVoE= X-Received: by 2002:a4a:7019:0:b0:5c1:a2a0:2887 with SMTP id 006d021491bc7-5c1ad8fa098mr3813416eaf.0.1718834133218; Wed, 19 Jun 2024 14:55:33 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:77c6:0:b0:530:392d:d678 with HTTP; Wed, 19 Jun 2024 14:55:32 -0700 (PDT) In-Reply-To: References: <65F95FD4-CBEA-4E66-AE63-EBC9F617C988@gmail.com> <7678da90-521-3b52-4bb5-11bc9bdf6d1@appl-ecosys.com> <85742b59-6aa1-4527-84fd-a2de76665a9f@aklaver.com> From: "David G. Johnston" Date: Wed, 19 Jun 2024 14:55:32 -0700 Message-ID: Subject: Re: Transaction issue To: Adrian Klaver Cc: Rich Shepard , "pgsql-general@postgresql.org" Content-Type: multipart/alternative; boundary="000000000000f03e71061b45414f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f03e71061b45414f Content-Type: text/plain; charset="UTF-8" On Wednesday, June 19, 2024, Adrian Klaver wrote: > On 6/19/24 14:33, Rich Shepard wrote: > >> On Wed, 19 Jun 2024, Adrian Klaver wrote: >> >> I should have added to previous post: >>> What is the exact command string you are using to launch psql? >>> >> >> $ psql bustrac >> > > I find it difficult to believe that actually runs. > > psql -d test -U postgres -bustrac > > psql: hint: Try "psql --help" for more information. You hallucinated a dash in front of the bustrac. psql bustract is a perfectly valid psql command. User gets inferred from the OS user. David J. --000000000000f03e71061b45414f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, June 19, 2024, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 6/19/24 14:33, Rich Shepard wrote:
On Wed, 19 Jun 2024, Adrian Klaver wrote:

I should have added to previous post:
What is the exact command string you are using to launch psql?

$ psql bustrac

I find it difficult to believe that actually runs.

psql -d test -U postgres -bustrac

psql: hint: Try "psql --help" for more information.
<= div>
You hallucinated a dash in front of the bustrac. =C2=A0p= sql bustract is a perfectly valid psql command.=C2=A0 User gets inferred fr= om the OS user.

David J.

--000000000000f03e71061b45414f--