Re: Transaction issue

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Transaction issue
Дата
Msg-id CAKFQuwZP6gsWC9UZroWQZK51g0cbd7A5BCZ8kTOAEsag+btaLQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Transaction issue  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Transaction issue
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Transaction issue
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Transaction issue