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 по дате отправления: