bug#57798: 29.0.50; M-x sql-postgres conflates initial input from M-x sql-sqlite

bug#57798: 29.0.50; M-x sql-postgres conflates initial input from M-x sql-sqlite

[Jean Louis]

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/

bug#57798: 29.0.50; M-x sql-postgres conflates initial input from M-x sql-sqlite

[Lars Ingebrigtsen]

Jean Louis <bugs@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?

bug#57798: 29.0.50; M-x sql-postgres conflates initial input from M-x sql-sqlite

[Jean Louis]

* Lars Ingebrigtsen <larsi@gnus.org> [2022-09-14 16:08]:
> Jean Louis <bugs@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/