public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: Rich Shepard <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Transaction issue
Date: Wed, 19 Jun 2024 17:27:03 -0700
Message-ID: <CAKFQuwZP6gsWC9UZroWQZK51g0cbd7A5BCZ8kTOAEsag+btaLQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<CAKFQuwYDLaLFN3ZaUkPgNvcGOxt992kftjFX1ShFo9LXEnbPEA@mail.gmail.com>
	<[email protected]>

On Wed, Jun 19, 2024 at 5:16 PM Adrian Klaver <[email protected]>
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=#
>
> 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.

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Transaction issue
  In-Reply-To: <CAKFQuwZP6gsWC9UZroWQZK51g0cbd7A5BCZ8kTOAEsag+btaLQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox