public inbox for [email protected]help / color / mirror / Atom feed
Re: Transaction issue 6+ messages / 3 participants [nested] [flat]
* Re: Transaction issue @ 2024-06-19 21:55 David G. Johnston <[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 22:14 Rob Sargent <[email protected]> parent: David G. Johnston <[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-20 00:16 Adrian Klaver <[email protected]> parent: 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-20 00:18 Adrian Klaver <[email protected]> parent: Rob Sargent <[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-20 00:27 David G. Johnston <[email protected]> parent: 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-20 00:30 Adrian Klaver <[email protected]> parent: David G. Johnston <[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