From unknown Sat Jun 14 14:21:54 2025 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.509 (Entity 5.509) Content-Type: text/plain; charset=utf-8 From: bug#57798 <57798@debbugs.gnu.org> To: bug#57798 <57798@debbugs.gnu.org> Subject: Status: 29.0.50; M-x sql-postgres conflates initial input from M-x sql-sqlite Reply-To: bug#57798 <57798@debbugs.gnu.org> Date: Sat, 14 Jun 2025 21:21:54 +0000 retitle 57798 29.0.50; M-x sql-postgres conflates initial input from M-x sq= l-sqlite reassign 57798 emacs submitter 57798 Jean Louis severity 57798 normal thanks From debbugs-submit-bounces@debbugs.gnu.org Wed Sep 14 05:55:43 2022 Received: (at submit) by debbugs.gnu.org; 14 Sep 2022 09:55:43 +0000 Received: from localhost ([127.0.0.1]:53773 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1oYP7P-0001va-1f for submit@debbugs.gnu.org; Wed, 14 Sep 2022 05:55:43 -0400 Received: from lists.gnu.org ([209.51.188.17]:38182) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1oYP7N-0001vT-Tv for submit@debbugs.gnu.org; Wed, 14 Sep 2022 05:55:42 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:43794) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oYP7N-00057S-NF for bug-gnu-emacs@gnu.org; Wed, 14 Sep 2022 05:55:41 -0400 Received: from stw1.rcdrun.com ([217.170.207.13]:54007) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oYP7L-0002X5-Lq for bug-gnu-emacs@gnu.org; Wed, 14 Sep 2022 05:55:41 -0400 Received: from localhost ([::ffff:102.85.174.124]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 00000000000B5A74.000000006321A4F8.00002A63; Wed, 14 Sep 2022 02:55:03 -0700 From: Jean Louis To: bug-gnu-emacs@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 Message-ID: <86leqmsj64.fsf@protected.rcdrun.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Received-SPF: pass client-ip=217.170.207.13; envelope-from=admin@protected.rcdrun.com; helo=stw1.rcdrun.com X-Spam_score_int: 0 X-Spam_score: -0.1 X-Spam_bar: / X-Spam_report: (-0.1 / 5.0 requ) BAYES_00=-1.9, DATE_IN_PAST_03_06=1.592, HEADER_FROM_DIFFERENT_DOMAINS=0.25, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=no autolearn_force=no X-Spam_action: no action X-Spam-Score: -0.1 (/) X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.1 (-) 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/ From debbugs-submit-bounces@debbugs.gnu.org Wed Sep 14 09:08:09 2022 Received: (at 57798) by debbugs.gnu.org; 14 Sep 2022 13:08:09 +0000 Received: from localhost ([127.0.0.1]:54127 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1oYS7d-0003CT-CJ for submit@debbugs.gnu.org; Wed, 14 Sep 2022 09:08:09 -0400 Received: from quimby.gnus.org ([95.216.78.240]:48828) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1oYS7a-0003Bv-Sa for 57798@debbugs.gnu.org; Wed, 14 Sep 2022 09:08:08 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Type:MIME-Version:Message-ID:Date:References: In-Reply-To:Subject:Cc:To:From:Sender:Reply-To:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=3Psb+cfbaSsvoUTaaw4AGCUNCjwjKmfyCnFEx/larY8=; b=rZ0/pGiVlc0CkArXDStCh2j99X WfYVJHq4ps8N2QTeBkla5IdNtgSjmv9sREBslUOo13zDyLrmXi9RvOqsCkWbCYSqK5WhK/06iE6WV gNHyvOjEOetQifofGxqAGqWCouk9sV8ibJbR8mof7567GAbwiAWe2JDXQVn4tUpp107g=; Received: from [84.212.220.105] (helo=joga) by quimby.gnus.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oYS7R-0006iE-Uv; Wed, 14 Sep 2022 15:08:00 +0200 From: Lars Ingebrigtsen To: Jean Louis Subject: Re: bug#57798: 29.0.50; M-x sql-postgres conflates initial input from M-x sql-sqlite In-Reply-To: <86leqmsj64.fsf@protected.rcdrun.com> (Jean Louis's message of "Wed, 14 Sep 2022 06:56:35 +0300") References: <86leqmsj64.fsf@protected.rcdrun.com> X-Now-Playing: Joan as Police Woman's _Joanthology (3)_: "She Watch Channel Zero (Live at the BBC)" Date: Wed, 14 Sep 2022 15:07:57 +0200 Message-ID: <8735cu9k9e.fsf@gnus.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Spam-Report: Spam detection software, running on the system "quimby.gnus.org", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see @@CONTACT_ADDRESS@@ for details. Content preview: Jean Louis 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 tri [...] Content analysis details: (-2.9 points, 5.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -1.0 ALL_TRUSTED Passed through trusted hosts only via SMTP -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] X-Spam-Score: -2.3 (--) X-Debbugs-Envelope-To: 57798 Cc: 57798@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) Jean Louis 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? From debbugs-submit-bounces@debbugs.gnu.org Thu Sep 15 03:34:15 2022 Received: (at 57798) by debbugs.gnu.org; 15 Sep 2022 07:34:15 +0000 Received: from localhost ([127.0.0.1]:56891 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1oYjO2-000249-OV for submit@debbugs.gnu.org; Thu, 15 Sep 2022 03:34:15 -0400 Received: from stw1.rcdrun.com ([217.170.207.13]:57581) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1oYjO1-00023w-24 for 57798@debbugs.gnu.org; Thu, 15 Sep 2022 03:34:13 -0400 Received: from localhost ([::ffff:102.83.248.126]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 00000000000B5AC5.000000006322D56C.000034BF; Thu, 15 Sep 2022 00:34:04 -0700 Date: Thu, 15 Sep 2022 10:33:21 +0300 From: Jean Louis To: Lars Ingebrigtsen Subject: Re: bug#57798: 29.0.50; M-x sql-postgres conflates initial input from M-x sql-sqlite Message-ID: References: <86leqmsj64.fsf@protected.rcdrun.com> <8735cu9k9e.fsf@gnus.org> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: <8735cu9k9e.fsf@gnus.org> User-Agent: Mutt/+ () (2022-06-11) X-Spam-Score: -0.0 (/) X-Debbugs-Envelope-To: 57798 Cc: 57798@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) * Lars Ingebrigtsen [2022-09-14 16:08]: > Jean Louis 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/