Re: Transaction issue - Mailing list pgsql-general

From David G. Johnston
Subject Re: Transaction issue
Date
Msg-id CAKFQuwZP6gsWC9UZroWQZK51g0cbd7A5BCZ8kTOAEsag+btaLQ@mail.gmail.com
Whole thread Raw
In response to Re: Transaction issue  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Transaction issue
List pgsql-general
On Wed, Jun 19, 2024 at 5:16 PM Adrian Klaver <adrian.klaver@aklaver.com> 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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Transaction issue
Next
From: Adrian Klaver
Date:
Subject: Re: Transaction issue