public inbox for [email protected]
help / color / mirror / Atom feedRe: Transaction issue
6+ messages / 3 participants
[nested] [flat]
* Re: Transaction issue
@ 2024-06-19 21:55 David G. Johnston <[email protected]>
2024-06-19 22:14 ` Re: Transaction issue Rob Sargent <[email protected]>
2024-06-20 00:16 ` Re: Transaction issue Adrian Klaver <[email protected]>
0 siblings, 2 replies; 6+ messages in thread
From: David G. Johnston @ 2024-06-19 21:55 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; +Cc: Rich Shepard <[email protected]>; pgsql-general
On Wednesday, June 19, 2024, Adrian Klaver <[email protected]>
wrote:
> On 6/19/24 14:33, Rich Shepard wrote:
>
>> On Wed, 19 Jun 2024, Adrian Klaver wrote:
>>
>> I should have added to previous post:
>>> What is the exact command string you are using to launch psql?
>>>
>>
>> $ psql bustrac
>>
>
> I find it difficult to believe that actually runs.
>
> psql -d test -U postgres -bustrac
>
> psql: hint: Try "psql --help" for more information.
You hallucinated a dash in front of the bustrac. psql bustract is a
perfectly valid psql command. User gets inferred from the OS user.
David J.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Transaction issue
2024-06-19 21:55 Re: Transaction issue David G. Johnston <[email protected]>
@ 2024-06-19 22:14 ` Rob Sargent <[email protected]>
2024-06-20 00:18 ` Re: Transaction issue Adrian Klaver <[email protected]>
1 sibling, 1 reply; 6+ messages in thread
From: Rob Sargent @ 2024-06-19 22:14 UTC (permalink / raw)
To: [email protected]
On 6/19/24 15:55, David G. Johnston wrote:
> On Wednesday, June 19, 2024, Adrian Klaver <[email protected]>
> wrote:
>
> On 6/19/24 14:33, Rich Shepard wrote:
>
> On Wed, 19 Jun 2024, Adrian Klaver wrote:
>
> I should have added to previous post:
> What is the exact command string you are using to launch psql?
>
>
> $ psql bustrac
>
>
> I find it difficult to believe that actually runs.
>
> psql -d test -U postgres -bustrac
>
> psql: hint: Try "psql --help" for more information.
>
>
> You hallucinated a dash in front of the bustrac. psql bustract is a
> perfectly valid psql command. User gets inferred from the OS user.
>
> David J.
>
Oh no. Adrian is an AI?!!
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Transaction issue
2024-06-19 21:55 Re: Transaction issue David G. Johnston <[email protected]>
2024-06-19 22:14 ` Re: Transaction issue Rob Sargent <[email protected]>
@ 2024-06-20 00:18 ` Adrian Klaver <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: Adrian Klaver @ 2024-06-20 00:18 UTC (permalink / raw)
To: Rob Sargent <[email protected]>; [email protected]
On 6/19/24 15:14, Rob Sargent wrote:
>
>
> On 6/19/24 15:55, David G. Johnston wrote:
>> On Wednesday, June 19, 2024, Adrian Klaver <[email protected]>
>> wrote:
>>
>> On 6/19/24 14:33, Rich Shepard wrote:
>>
>> On Wed, 19 Jun 2024, Adrian Klaver wrote:
>>
>> I should have added to previous post:
>> What is the exact command string you are using to launch psql?
>>
>>
>> $ psql bustrac
>>
>>
>> I find it difficult to believe that actually runs.
>>
>> psql -d test -U postgres -bustrac
>>
>> psql: hint: Try "psql --help" for more information.
>>
>>
>> You hallucinated a dash in front of the bustrac. psql bustract is a
>> perfectly valid psql command. User gets inferred from the OS user.
>>
>> David J.
>>
> Oh no. Adrian is an AI?!!
>
No, I am perfectly capable of providing incorrect answers solely on the
basis of my 'little gray cells'.
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Transaction issue
2024-06-19 21:55 Re: Transaction issue David G. Johnston <[email protected]>
@ 2024-06-20 00:16 ` Adrian Klaver <[email protected]>
2024-06-20 00:27 ` Re: Transaction issue David G. Johnston <[email protected]>
1 sibling, 1 reply; 6+ messages in thread
From: Adrian Klaver @ 2024-06-20 00:16 UTC (permalink / raw)
To: David G. Johnston <[email protected]>; +Cc: Rich Shepard <[email protected]>; pgsql-general
On 6/19/24 14:55, David G. Johnston wrote:
> On Wednesday, June 19, 2024, Adrian Klaver <[email protected]
> <mailto:[email protected]>> wrote:
>
> On 6/19/24 14:33, Rich Shepard wrote:
>
> On Wed, 19 Jun 2024, Adrian Klaver wrote:
>
> I should have added to previous post:
> What is the exact command string you are using to launch psql?
>
>
> $ psql bustrac
>
>
> I find it difficult to believe that actually runs.
>
> psql -d test -U postgres -bustrac
>
> psql: hint: Try "psql --help" for more information.
>
>
> 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
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.
>
> David J.
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Transaction issue
2024-06-19 21:55 Re: Transaction issue David G. Johnston <[email protected]>
2024-06-20 00:16 ` Re: Transaction issue Adrian Klaver <[email protected]>
@ 2024-06-20 00:27 ` David G. Johnston <[email protected]>
2024-06-20 00:30 ` Re: Transaction issue Adrian Klaver <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: David G. Johnston @ 2024-06-20 00:27 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; +Cc: Rich Shepard <[email protected]>; pgsql-general
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Transaction issue
2024-06-19 21:55 Re: Transaction issue David G. Johnston <[email protected]>
2024-06-20 00:16 ` Re: Transaction issue Adrian Klaver <[email protected]>
2024-06-20 00:27 ` Re: Transaction issue David G. Johnston <[email protected]>
@ 2024-06-20 00:30 ` Adrian Klaver <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: Adrian Klaver @ 2024-06-20 00:30 UTC (permalink / raw)
To: David G. Johnston <[email protected]>; +Cc: Rich Shepard <[email protected]>; pgsql-general
On 6/19/24 17:27, David G. Johnston wrote:
> On Wed, Jun 19, 2024 at 5:16 PM Adrian Klaver <[email protected]
> <mailto:[email protected]>> 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
[email protected]
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-06-20 00:30 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-19 21:55 Re: Transaction issue David G. Johnston <[email protected]>
2024-06-19 22:14 ` Rob Sargent <[email protected]>
2024-06-20 00:18 ` Adrian Klaver <[email protected]>
2024-06-20 00:16 ` Adrian Klaver <[email protected]>
2024-06-20 00:27 ` David G. Johnston <[email protected]>
2024-06-20 00:30 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox