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 1sK5hI-008Fc9-BO for pgsql-general@arkaria.postgresql.org; Thu, 20 Jun 2024 00:30:40 +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 1sK5hG-00ANYN-3T for pgsql-general@arkaria.postgresql.org; Thu, 20 Jun 2024 00:30:38 +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 1sK5hF-00ANYF-Oo for pgsql-general@lists.postgresql.org; Thu, 20 Jun 2024 00:30:38 +0000 Received: from fout7-smtp.messagingengine.com ([103.168.172.150]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sK5hE-002A6c-56 for pgsql-general@postgresql.org; Thu, 20 Jun 2024 00:30:37 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailfout.nyi.internal (Postfix) with ESMTP id 59B831380254; Wed, 19 Jun 2024 20:30:35 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Wed, 19 Jun 2024 20:30:35 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1718843435; x=1718929835; bh=pijaEpiuzr9AJmIJ0FhTpt+DPRKINzhWtNranuvZHQk=; b= U3YTkqKdiDvxiWABkNiRKj2AJ8WkMZRd1/fdx0YEM19ekw4tN7orfdLK6Q2mhKUO coP56jpU3NH+oHVYzqFkhhUs53rg1LEAkWZLkTmqcdwRH2t4RiJp1orUqH9ULHwO 8o4M1Nn+05u2F5jtuPHOH3NW/PoeOsbWPSCjr6Ve3dSIAypsPZSFmdvUa8dxOphY dXUiA2Vj9NW+7iq+eAAPZW5wXEQh/mwG02HQM0iBCmBrqCE+6GzZA/zUHVU4uG9p c0lhOZwvobYqgnIMShfCobsKOBF3oE5Unz0+ttB66ULgXaDEfbrgl6WC98zcYAj6 Bl2IalekXuFaoJRKkU7SAA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1718843435; x= 1718929835; bh=pijaEpiuzr9AJmIJ0FhTpt+DPRKINzhWtNranuvZHQk=; b=f 11+e6iWFTUyuUJ/NTvXoIpFxkoCR9U2KcHFAdaP89l3vDzO4k/ruYTRypBznr3vD Fp3NQBFcv/hfnYEUiljJVwLLoS/yOGKjoJV1pHfbtgHoNgq1bQY2cmCi0MslGcZ7 fVGr9X3CYVrvKpP/OioL9vcCI3vQbAVpGbJAeNEXZFh8kc5s/p4woPnmzkfaCE7Q KsSRGwb7L0bIneSstfUePCKqz3/Xs/RsF/KYwOwZvSmYgmWZWgnGbs8+FG9HF8dd TozmL3mRwWWdACMMV7I/y3yWW3HGbNAXgQJbJlt87R3CM+mPQNks9gloS0OyKpz6 LFAOjKFtdDFJzJPZEi3ag== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrfeefuddgfeeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddtvdejnecuhfhrohhmpeetughr ihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtg homheqnecuggftrfgrthhtvghrnhepfeegfeeiuedtgffgteeggfehkeejheetieeliefg teeikeejvdeiveeigfehvedtnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpe hmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 19 Jun 2024 20:30:34 -0400 (EDT) Message-ID: Date: Wed, 19 Jun 2024 17:30:34 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Transaction issue To: "David G. Johnston" Cc: Rich Shepard , "pgsql-general@postgresql.org" References: <65F95FD4-CBEA-4E66-AE63-EBC9F617C988@gmail.com> <7678da90-521-3b52-4bb5-11bc9bdf6d1@appl-ecosys.com> <85742b59-6aa1-4527-84fd-a2de76665a9f@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 6/19/24 17:27, David G. Johnston wrote: > On Wed, Jun 19, 2024 at 5:16 PM Adrian Klaver > wrote: > > > 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]] Yep, completely missed that. > > You like to specify both dbname and username via options but as shown > one can also use arguments. > > David J. > -- Adrian Klaver adrian.klaver@aklaver.com