bug#47357: 28.0.50; sql-list-tables: Executing SQL command... takes indefinite time after creation of new table

[Michael Mauger via "Bug reports for GNU Emacs, the Swiss army knife of text editors" <bug-gnu-emacs@gnu.org>]

I think the fix got pushed to 27 but I never cherry-picked it for 28.  (It's been a tough Spring, hopefully settling down now)

However, this with the `sql-interactive-remove-continuation-prompt`changes seem to have caused some issues which I am debugging.

--
MICHAEL@MAUGER.COM // FSF and SFConservancy // GNU Emacs sql.el maintainer

------- Original Message -------
On Sunday, June 26th, 2022 at 2:32 PM, Lars Ingebrigtsen <larsi@gnus.org> wrote:


> Michael Mauger mmauger@protonmail.com writes:
>
> > The default prompt regexp for Postgres in sql.el is not correct and a
> > fix will be made for Emacs 28 and master for that.
> >
> > I will also add a function to sql.el to verify the prompt as best I can
> > to Emacs-28 so at least an error message or workaround can be provided.
> >
> > On master, I'll submit a similar change to comint.el to protect all
> > Comint derived modes if they use the redirect logic and prevent the
> > hanging behavior.
> >
> > I was aware of the bad prompt regexp but had forgotten to commit that
> > change. I'll go ahead and do that now.
>
>
> (I'm going through old bug reports that unfortunately weren't resolved
> at the time.)
>
> This was some months ago, and I had a look at the commit log for sql.el
> now, but it doesn't look like this change was pushed? (But I may be
> looking for the wrong thing here.)
>
> --
> (domestic pets only, the antidote for overdose, milk.)
> bloggy blog: http://lars.ingebrigtsen.no