GNU bug report logs - #57798
29.0.50; M-x sql-postgres conflates initial input from M-x sql-sqlite

Previous Next

To reply to this bug, email your comments to 57798 AT debbugs.gnu.org.

Toggle the display of automated, internal messages from the tracker.

Message #5 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Jean Louis <bugs <at> gnu.support>
To: bug-gnu-emacs <at> gnu.org
Subject: 29.0.50; M-x sql-postgres conflates initial input from M-x sql-sqlite
Date: Wed, 14 Sep 2022 06:56:35 +0300

I had a long running session of M-x sql-postgres

During the session I have initiated M-x sql-sqlite and worked with
database.

Then I have exited from PostgreSQL session

Then I have tried invoking M-x sql-postgres again.

And then I get this error:

psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL:  database "/home/data1/protected/tmp/mybusiness" does not exist

Process SQL: Postgres exited abnormally with code 2

Whereby the SQLite database I have been using was:
"/home/data1/protected/tmp/mybusiness"

whereby PostgreSQL database I was using was "mybusiness"

Problem is in the prompt "Database: " that conflates history of other
database and offers me initial input from SQLite instead of initial
input of PostgreSQL database.



In GNU Emacs 29.0.50 (build 1, x86_64-pc-linux-gnu, X toolkit, cairo version 1.17.6, Xaw3d scroll bars)
 of 2022-09-06 built on protected.rcdrun.com

If Emacs crashed, and you have the Emacs process in the gdb debugger,
please include the output from the following gdb commands:
    'bt full' and 'xbacktrace'.
For information about debugging Emacs, please read the file
/home/data1/protected/Programming/Software/emacs/etc/DEBUG.

-- 
Jean

Take action in Free Software Foundation campaigns:
https://www.fsf.org/campaigns

In support of Richard M. Stallman
https://stallmansupport.org/

Message #8 received at 57798 <at> debbugs.gnu.org (full text, mbox):

From: Lars Ingebrigtsen <larsi <at> gnus.org>
To: Jean Louis <bugs <at> gnu.support>
Cc: 57798 <at> debbugs.gnu.org
Subject: Re: bug#57798: 29.0.50; M-x sql-postgres conflates initial input
 from M-x sql-sqlite
Date: Wed, 14 Sep 2022 15:07:57 +0200

Jean Louis <bugs <at> gnu.support> writes:

> I had a long running session of M-x sql-postgres
>
> During the session I have initiated M-x sql-sqlite and worked with
> database.
>
> Then I have exited from PostgreSQL session
>
> Then I have tried invoking M-x sql-postgres again.

Are you running sql-postgres and sql-sqlite in the same buffer?

Message #11 received at 57798 <at> debbugs.gnu.org (full text, mbox):

From: Jean Louis <bugs <at> gnu.support>
To: Lars Ingebrigtsen <larsi <at> gnus.org>
Cc: 57798 <at> debbugs.gnu.org
Subject: Re: bug#57798: 29.0.50; M-x sql-postgres conflates initial input
 from M-x sql-sqlite
Date: Thu, 15 Sep 2022 10:33:21 +0300

* Lars Ingebrigtsen <larsi <at> gnus.org> [2022-09-14 16:08]:
> Jean Louis <bugs <at> gnu.support> writes:
> 
> > I had a long running session of M-x sql-postgres
> >
> > During the session I have initiated M-x sql-sqlite and worked with
> > database.
> >
> > Then I have exited from PostgreSQL session
> >
> > Then I have tried invoking M-x sql-postgres again.
> 
> Are you running sql-postgres and sql-sqlite in the same buffer?

They use different buffers. Problem is in the default initial input of
"Database: " prompt.

It makes no sense that after invoking {M-x sql-sqlite RET} the
subsequent invocation of {C-u M-x sql-postgres RET} has default
initial input in the "Database: " prompt, something like this:

/home/data1/protected/tmp/business

Because PostgreSQL databases are not file names.

I hope that now it is clear how it comes to conflation of initial
input. Subject is not clear enough.

-- 
Jean

Take action in Free Software Foundation campaigns:
https://www.fsf.org/campaigns

In support of Richard M. Stallman
https://stallmansupport.org/

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.