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 1sK5eW-008FQV-0f for pgsql-general@arkaria.postgresql.org; Thu, 20 Jun 2024 00:27:48 +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 1sK5eT-00AI5Y-5C for pgsql-general@arkaria.postgresql.org; Thu, 20 Jun 2024 00:27:46 +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 1sK5eS-00AI5Q-O3 for pgsql-general@lists.postgresql.org; Thu, 20 Jun 2024 00:27:45 +0000 Received: from mail-oo1-xc2b.google.com ([2607:f8b0:4864:20::c2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sK5eR-002YXW-H6 for pgsql-general@postgresql.org; Thu, 20 Jun 2024 00:27:45 +0000 Received: by mail-oo1-xc2b.google.com with SMTP id 006d021491bc7-5c1a6685cd5so141791eaf.1 for ; Wed, 19 Jun 2024 17:27:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718843261; x=1719448061; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=SCybF+bnQuTCLFNRszG/TL895g5KVX8QcQCpo6nfxP0=; b=OY2nD7LgUeocCqbB/pI6PW0TvoiRZH3/A1GTEpELQ9EnnzWysnJVARybLx+GD+ObFL w22FsX8efa3/Bm6Ecs6brmuJlbYFrl+uhwMdtI6A63oXk7VB0qW61B3XasjdfM4M5G0/ 27EOR2XKJCI1pKDf5vZeDlvsg1XhKaRnaixCFAs9WQjHVmpi54QC9R0VZbvBdzi9fu80 LH9GkR52T2R4D9JWeTLtmQ7roNKY/QWdjR36xv8cqOhdy9pz30mZCkQR0mIt6P3cSvmT Jqu7oVcCMl58kdwsa2cLA/luoI6SPYljEK6HXv+66eCp5wKzkJ8QL4s3EswGV3mX63U8 WGoA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718843261; x=1719448061; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=SCybF+bnQuTCLFNRszG/TL895g5KVX8QcQCpo6nfxP0=; b=PNefDzkRdRTRaoFN+nEcXtNCpD6zbF92dQ66ndA7a5cmTjRPnBe9bldXIuB0rH8keQ McjwIpTKkBUneTqX/Hlc3Dxm6lHld4mILYnPmjpPAoI8sm6yDus5DqKGu1ET+oG6Au6n L/Uwt4WfrFvLFGic9V58XTokYE9DR5mNX8QA9TrbcJ7HqIEskaINIuIg9MhFPwKJyV/m SCr+qz9AGeU8T1RIM/xHdb1mTwDYSHVpleoVKmHrZZBKJXIMx1PvGafCNfR0C/XLoLUF ntOlJUPUHrIldFZvOWY7JRpjxgRD/XwvXibMGrCrbhasGk619vXIouX2JAe+cT7EXAbP PC5Q== X-Forwarded-Encrypted: i=1; AJvYcCULWuFsAKZzmJTiE5ItgY2sec6pdhPRLByFYqScMF4kCYMLUwyAcvNrfHfUMOt4FqE1JSYhuXrTSkVaLsQhYAn0nbRqhDlXuw/hZmZU X-Gm-Message-State: AOJu0Ywyc9+2Z7XAGlgDl2K/pL4pD6lCtAV0fQ7Wu/GU1U4sxLSx7dDl EosH28z6oAVwPzUEJZP00qF6LN+tRAcmNO39K5poCcsxIBcUXgceEk37f8oIr7WiZdGyPG9etat +CtebDIOePUjGv8JtvVSfJYEt+2U= X-Google-Smtp-Source: AGHT+IEG2MGmHvr0CpIqhOFaEA51tDUmYwSEUnGJMdILfwWD0PZ95lejIKPphupyDQW7wwTXq8fm67XA4XWmLcPvk4Q= X-Received: by 2002:a4a:3503:0:b0:5b1:bf03:d1c6 with SMTP id 006d021491bc7-5c1adae926amr4123642eaf.1.1718843261003; Wed, 19 Jun 2024 17:27:41 -0700 (PDT) MIME-Version: 1.0 References: <65F95FD4-CBEA-4E66-AE63-EBC9F617C988@gmail.com> <7678da90-521-3b52-4bb5-11bc9bdf6d1@appl-ecosys.com> <85742b59-6aa1-4527-84fd-a2de76665a9f@aklaver.com> In-Reply-To: From: "David G. Johnston" Date: Wed, 19 Jun 2024 17:27:03 -0700 Message-ID: Subject: Re: Transaction issue To: Adrian Klaver Cc: Rich Shepard , "pgsql-general@postgresql.org" Content-Type: multipart/alternative; boundary="000000000000ff2e62061b476134" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ff2e62061b476134 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Jun 19, 2024 at 5:16=E2=80=AFPM Adrian Klaver wrote: > > > > > You hallucinated a dash in front of the bustrac. psql bustract is a > > perfectly valid psql command. User gets inferred from the OS user. > > As in?: > > psql -d test -U postgres bustrac > Well no, that is the specification of -U is the exact opposite of "user gets inferred from the OS user". psql: warning: extra command-line argument "bustrac" ignored > psql (16.3 (Ubuntu 16.3-1.pgdg22.04+1), server 15.7 (Ubuntu > 15.7-1.pgdg22.04+1)) > Type "help" for help. > > test=3D# > > In which case bustrac is ignored. > > You are missing the fact that bustrac is the name of the database so when you specify the -d option you are being redundant and being told that by psql. psql [option...] [dbname [username]] You like to specify both dbname and username via options but as shown one can also use arguments. David J. --000000000000ff2e62061b476134 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Jun 19, 2024 at 5:16=E2=80=AFPM Adrian Klaver <= adrian.klaver@aklaver.com&= gt; wrote:

>
> You hallucinated a dash in front of the bustrac. =C2=A0psql bustract i= s a
> perfectly valid psql command.=C2=A0 User gets inferred from the OS use= r.

As in?:

psql -d test -U postgres=C2=A0 bustrac

We= ll no, that is the specification of -U is the exact opposite of "user = gets inferred from the OS user".

psql: warning: extra command-line argument "bustrac" ignored
psql (16.3 (Ubuntu 16.3-1.pgdg22.04+1), server 15.7 (Ubuntu
15.7-1.pgdg22.04+1))
Type "help" for help.

test=3D#

In which case bustrac is ignored.


You= are missing the fact that bustrac is the name of the database so when you = specify the -d option you are being redundant and being told that by psql.<= /div>

psql [option...] [dbname [username]]

<= /div>
You like to specify both dbname and username via options but as sho= wn one can also use arguments.

David J.

--000000000000ff2e62061b476134--