bug#46061: 28.0.50; error "‘'postgres’ is not a known product

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Jean Louis]

After M-x sql-postgres and clicking on the menu item SQL, I get this
error:

Debugger entered--Lisp error: (error "‘'postgres’ is not a known product; use ‘sql-add-product’ to add it first.")
  signal(error ("‘'postgres’ is not a known product; use ‘sql-add-p..."))
  error("`%s' is not a known product; use `sql-add-product' to add it first." 'postgres)
  sql-get-product-feature('postgres :sqli-login)
  sql-make-alternate-buffer-name()
  #f(compiled-function () #<bytecode 0x1e00135e2041>)()
  funcall(#f(compiled-function () #<bytecode 0x1e00135e2041>))
  (let ((sql-database '"my-database") (sql-password '"my-password") (sql-user '"my-username") (sql-product ''postgres)) (funcall '#f(compiled-function () #<bytecode 0x1e00135e2041>)))
  eval((let ((sql-database '"my-database") (sql-password '"my-password") (sql-user '"my-username") (sql-product ''postgres)) (funcall '#f(compiled-function () #<bytecode 0x1e00135e2041>))))
  #f(compiled-function (conn) #<bytecode -0x96a03124cfe7158>)(("local" (sql-product 'postgres) (sql-user "my-username") (sql-password "my-password") (sql-database "my-database")))
  mapcar(#f(compiled-function (conn) #<bytecode -0x96a03124cfe7158>) (("local" (sql-product 'postgres) (sql-user "my-username") (sql-password "my-password") (sql-database "my-database"))))
  sql-connection-menu-filter(("--" ["New SQLi Session" sql-product-interactive (sql-get-product-feature sql-product :sqli-comint-func)]))
  #f(compiled-function (menu) #<bytecode 0xfdb21298474a028>)(("--" ["New SQLi Session" sql-product-interactive (sql-get-product-feature sql-product :sqli-comint-func)]))

The value of variable `sql-product-alist' is:

Value:
((ansi :name "ANSI" :font-lock sql-mode-ansi-font-lock-keywords :statement sql-ansi-statement-starters)
 (db2 :name "DB2" :font-lock sql-mode-db2-font-lock-keywords :sqli-program sql-db2-program :sqli-options sql-db2-options :sqli-login sql-db2-login-params :sqli-comint-func sql-comint-db2 :prompt-regexp "^db2 => " :prompt-length 7 :prompt-cont-regexp "^db2 (cont\\.) => " :input-filter sql-escape-newlines-filter)
 (informix :name "Informix" :font-lock sql-mode-informix-font-lock-keywords :sqli-program sql-informix-program :sqli-options sql-informix-options :sqli-login sql-informix-login-params :sqli-comint-func sql-comint-informix :prompt-regexp "^> " :prompt-length 2 :syntax-alist
	   ((123 . "<")
	    (125 . ">")))
 (ingres :name "Ingres" :font-lock sql-mode-ingres-font-lock-keywords :sqli-program sql-ingres-program :sqli-options sql-ingres-options :sqli-login sql-ingres-login-params :sqli-comint-func sql-comint-ingres :prompt-regexp "^\\* " :prompt-length 2 :prompt-cont-regexp "^\\* ")
 (interbase :name "Interbase" :font-lock sql-mode-interbase-font-lock-keywords :sqli-program sql-interbase-program :sqli-options sql-interbase-options :sqli-login sql-interbase-login-params :sqli-comint-func sql-comint-interbase :prompt-regexp "^SQL> " :prompt-length 5)
 (linter :name "Linter" :font-lock sql-mode-linter-font-lock-keywords :sqli-program sql-linter-program :sqli-options sql-linter-options :sqli-login sql-linter-login-params :sqli-comint-func sql-comint-linter :prompt-regexp "^SQL>" :prompt-length 4)
 (mariadb :name "MariaDB" :free-software t :font-lock sql-mode-mariadb-font-lock-keywords :sqli-program sql-mariadb-program :sqli-options sql-mariadb-options :sqli-login sql-mariadb-login-params :sqli-comint-func sql-comint-mariadb :list-all "SHOW TABLES;" :list-table "DESCRIBE %s;" :prompt-regexp "^MariaDB \\[.*]> " :prompt-cont-regexp "^    [\"'`-]> " :syntax-alist
	  ((35 . "< b"))
	  :input-filter sql-remove-tabs-filter)
 (ms :name "Microsoft" :font-lock sql-mode-ms-font-lock-keywords :sqli-program sql-ms-program :sqli-options sql-ms-options :sqli-login sql-ms-login-params :sqli-comint-func sql-comint-ms :prompt-regexp "^[0-9]*>" :prompt-cont-regexp "^[0-9]*>" :prompt-length 5 :syntax-alist
     ((64 . "_"))
     :terminator
     ("^go" . "go"))
 (mysql :name "MySQL" :free-software t :font-lock sql-mode-mysql-font-lock-keywords :sqli-program sql-mysql-program :sqli-options sql-mysql-options :sqli-login sql-mysql-login-params :sqli-comint-func sql-comint-mysql :list-all "SHOW TABLES;" :list-table "DESCRIBE %s;" :prompt-regexp "^mysql> " :prompt-length 6 :prompt-cont-regexp "^    -> " :syntax-alist
	((35 . "< b")
	 (92 . "\\"))
	:input-filter sql-remove-tabs-filter)
 (oracle :name "Oracle" :font-lock sql-mode-oracle-font-lock-keywords :sqli-program sql-oracle-program :sqli-options sql-oracle-options :sqli-login sql-oracle-login-params :sqli-comint-func sql-comint-oracle :list-all sql-oracle-list-all :list-table sql-oracle-list-table :completion-object sql-oracle-completion-object :prompt-regexp "^SQL> " :prompt-length 5 :prompt-cont-regexp "^\\(?:[ ][ ][1-9]\\|[ ][1-9][0-9]\\|[1-9][0-9]\\{2\\}\\)[ ]\\{2\\}" :statement sql-oracle-statement-starters :syntax-alist
	 ((36 . "_")
	  (35 . "_"))
	 :terminator
	 ("\\(^/\\|;\\)" . "/")
	 :input-filter sql-placeholders-filter)
 (postgres :name "Postgres" :free-software t :font-lock sql-mode-postgres-font-lock-keywords :sqli-program sql-postgres-program :sqli-options sql-postgres-options :sqli-login sql-postgres-login-params :sqli-comint-func sql-comint-postgres :list-all
	   ("\\d+" . "\\dS+")
	   :list-table
	   ("\\d+ %s" . "\\dS+ %s")
	   :completion-object sql-postgres-completion-object :prompt-regexp "^[[:alnum:]_]*=[#>] " :prompt-length 5 :prompt-cont-regexp "^[[:alnum:]_]*[-(][#>] " :input-filter sql-remove-tabs-filter :terminator
	   ("\\(^\\s-*\\\\g\\|;\\)" . "\\g"))
 (solid :name "Solid" :font-lock sql-mode-solid-font-lock-keywords :sqli-program sql-solid-program :sqli-options sql-solid-options :sqli-login sql-solid-login-params :sqli-comint-func sql-comint-solid :prompt-regexp "^" :prompt-length 0)
 (sqlite :name "SQLite" :free-software t :font-lock sql-mode-sqlite-font-lock-keywords :sqli-program sql-sqlite-program :sqli-options sql-sqlite-options :sqli-login sql-sqlite-login-params :sqli-comint-func sql-comint-sqlite :list-all ".tables" :list-table ".schema %s" :completion-object sql-sqlite-completion-object :prompt-regexp "^sqlite> " :prompt-length 8 :prompt-cont-regexp "^   \\.\\.\\.> ")
 (sybase :name "Sybase" :font-lock sql-mode-sybase-font-lock-keywords :sqli-program sql-sybase-program :sqli-options sql-sybase-options :sqli-login sql-sybase-login-params :sqli-comint-func sql-comint-sybase :prompt-regexp "^SQL> " :prompt-length 5 :syntax-alist
	 ((64 . "_"))
	 :terminator
	 ("^go" . "go"))
 (vertica :name "Vertica" :sqli-program sql-vertica-program :sqli-options sql-vertica-options :sqli-login sql-vertica-login-params :sqli-comint-func sql-comint-vertica :list-all
	  ("\\d" . "\\dS")
	  :list-table "\\d %s" :prompt-regexp "^[[:alnum:]_]*=[#>] " :prompt-length 5 :prompt-cont-regexp "^[[:alnum:]_]*[-(][#>] "))



In GNU Emacs 28.0.50 (build 4, x86_64-pc-linux-gnu, X toolkit, cairo version 1.14.8, Xaw3d scroll bars)
 of 2021-01-01 built on protected.rcdrun.com
Repository revision: 30a1d5da7a43d51a97cbe8d91add9a26dd99df90
Repository branch: master
Windowing system distributor 'The X.Org Foundation', version 11.0.11907000
System Description: Hyperbola GNU/Linux-libre

Configured using:
 'configure --prefix=/package/text/emacs --with-modules
 --with-x-toolkit=lucid
 PKG_CONFIG_PATH=/home/data1/protected/GNUstep/Library/Libraries/pkgconfig:/usr/lib/pkgconfig'

Configured features:
XAW3D XPM JPEG TIFF GIF PNG RSVG CAIRO SOUND GPM DBUS GSETTINGS GLIB
NOTIFY INOTIFY ACL GNUTLS LIBXML2 FREETYPE HARFBUZZ M17N_FLT LIBOTF ZLIB
TOOLKIT_SCROLL_BARS LUCID X11 XDBE XIM MODULES THREADS JSON PDUMPER
LCMS2

Important settings:
  value of $LC_ALL: en_US.UTF-8
  value of $LANG: de_DE.UTF-8
  value of $XMODIFIERS: @im=exwm-xim
  locale-coding-system: utf-8-unix

Major mode: Lisp Interaction

Minor modes in effect:
  tooltip-mode: t
  global-eldoc-mode: t
  eldoc-mode: t
  electric-indent-mode: t
  mouse-wheel-mode: t
  tool-bar-mode: t
  menu-bar-mode: t
  file-name-shadow-mode: t
  global-font-lock-mode: t
  font-lock-mode: t
  blink-cursor-mode: t
  auto-composition-mode: t
  auto-encryption-mode: t
  auto-compression-mode: t
  line-number-mode: t
  transient-mark-mode: t

Load-path shadows:
None found.

Features:
(shadow sort hashcash mail-extr emacsbug message rmc puny dired
dired-loaddefs rfc822 mml easymenu mml-sec epa derived epg epg-config
gnus-util rmail rmail-loaddefs auth-source cl-seq eieio eieio-core
cl-macs eieio-loaddefs password-cache json map text-property-search
time-date subr-x seq byte-opt gv bytecomp byte-compile cconv mm-decode
mm-bodies mm-encode mail-parse rfc2231 mailabbrev gmm-utils mailheader
cl-loaddefs cl-lib sendmail rfc2047 rfc2045 ietf-drums mm-util
mail-prsvr mail-utils iso-transl tooltip eldoc electric uniquify
ediff-hook vc-hooks lisp-float-type mwheel term/x-win x-win
term/common-win x-dnd tool-bar dnd fontset image regexp-opt fringe
tabulated-list replace newcomment text-mode elisp-mode lisp-mode
prog-mode register page tab-bar menu-bar rfn-eshadow isearch timer
select scroll-bar mouse jit-lock font-lock syntax facemenu font-core
term/tty-colors frame minibuffer cl-generic cham georgian utf-8-lang
misc-lang vietnamese tibetan thai tai-viet lao korean japanese eucjp-ms
cp51932 hebrew greek romanian slovak czech european ethiopic indian
cyrillic chinese composite charscript charprop case-table epa-hook
jka-cmpr-hook help simple abbrev obarray cl-preloaded nadvice button
loaddefs faces cus-face macroexp files window text-properties overlay
sha1 md5 base64 format env code-pages mule custom widget
hashtable-print-readable backquote threads dbusbind inotify lcms2
dynamic-setting system-font-setting font-render-setting cairo x-toolkit
x multi-tty make-network-process emacs)

Memory information:
((conses 16 55368 5781)
 (symbols 48 7329 0)
 (strings 32 20348 2406)
 (string-bytes 1 649572)
 (vectors 16 13014)
 (vector-slots 8 226056 20087)
 (floats 8 26 39)
 (intervals 56 256 0)
 (buffers 984 12))

-- 
Thanks,
Jean Louis
⎔ λ 🄯 𝍄 𝌡 𝌚

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Lars Ingebrigtsen]

Jean Louis <bugs@gnu.support> writes:

> After M-x sql-postgres and clicking on the menu item SQL, I get this
> error:
>
> Debugger entered--Lisp error: (error "‘'postgres’ is not a known product; use ‘sql-add-product’ to add it first.")

What's the value of the `sql-connection-alist' variable in the SQL buffer?

-- 
(domestic pets only, the antidote for overdose, milk.)
   bloggy blog: http://lars.ingebrigtsen.no

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Lars Ingebrigtsen]

Lars Ingebrigtsen <larsi@gnus.org> writes:

> Jean Louis <bugs@gnu.support> writes:
>
>> After M-x sql-postgres and clicking on the menu item SQL, I get this
>> error:
>>
>> Debugger entered--Lisp error: (error "‘'postgres’ is not a known
>> product; use ‘sql-add-product’ to add it first.")
>
> What's the value of the `sql-connection-alist' variable in the SQL buffer?

More information was requested, but no response was given within a
month, so I'm closing this bug report.  If the problem still exists,
please respond to this email and we'll reopen the bug report.

(Benjamin Riefenstahl also reported that he couldn't reproduce the
problem.)

-- 
(domestic pets only, the antidote for overdose, milk.)
   bloggy blog: http://lars.ingebrigtsen.no

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Jean Louis]

* Lars Ingebrigtsen <larsi@gnus.org> [2021-01-25 00:31]:
> Jean Louis <bugs@gnu.support> writes:
> 
> > After M-x sql-postgres and clicking on the menu item SQL, I get this
> > error:
> >
> > Debugger entered--Lisp error: (error "‘'postgres’ is not a known product; use ‘sql-add-product’ to add it first.")
> 
> What's the value of the `sql-connection-alist' variable in the SQL buffer?

(("local" (sql-product 'postgres) (sql-user "username") (sql-password "password") (sql-database "mydatabase")))

This problem does not appear always and I cannot reproduce it.

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Lars Ingebrigtsen]

Jean Louis <bugs@gnu.support> writes:

>> What's the value of the `sql-connection-alist' variable in the SQL buffer?
>
> (("local" (sql-product 'postgres) (sql-user "username") (sql-password
> "password") (sql-database "mydatabase")))
>
> This problem does not appear always and I cannot reproduce it.

OK; reopening.

-- 
(domestic pets only, the antidote for overdose, milk.)
   bloggy blog: http://lars.ingebrigtsen.no

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Rudolf Schlatte]

Lars Ingebrigtsen <larsi@gnus.org> writes:

> Jean Louis <bugs@gnu.support> writes:
>
>>> What's the value of the `sql-connection-alist' variable in the SQL buffer?
>>
>> (("local" (sql-product 'postgres) (sql-user "username") (sql-password
>> "password") (sql-database "mydatabase")))
>>
>> This problem does not appear always and I cannot reproduce it.

Just a wild guess, but is there a misplaced quote in `(sql-product
'postgres)', i.e., should it be `(sql-product postgres)' instead?

(Please feel free to ignore this mail if that's not the case.)

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Jean Louis]

* Rudolf Schlatte <rudi@constantly.at> [2021-03-16 11:54]:
> Lars Ingebrigtsen <larsi@gnus.org> writes:
> 
> > Jean Louis <bugs@gnu.support> writes:
> >
> >>> What's the value of the `sql-connection-alist' variable in the SQL buffer?
> >>
> >> (("local" (sql-product 'postgres) (sql-user "username") (sql-password
> >> "password") (sql-database "mydatabase")))
> >>
> >> This problem does not appear always and I cannot reproduce it.
> 
> Just a wild guess, but is there a misplaced quote in `(sql-product
> 'postgres)', i.e., should it be `(sql-product postgres)' instead?
> 
> (Please feel free to ignore this mail if that's not the case.)

I am on development version. This does not happen always.

I do:

- M-x sql-postgres and enter

- then at the exact moment when I click SQL menu, I get this error:

Debugger entered--Lisp error: (error "‘'postgres’ is not a known product; use ‘sql-add-product’ to add it first.")
  signal(error ("‘'postgres’ is not a known product; use ‘sql-add-product’ to add it first."))
  error("`%s' is not a known product; use `sql-add-product' to add it first." 'postgres)
  sql-get-product-feature('postgres :sqli-login)
  sql-make-alternate-buffer-name()
  #f(compiled-function () #<bytecode 0x1e00184608d5>)()
  funcall(#f(compiled-function () #<bytecode 0x1e00184608d5>))
  (let ((sql-product ''postgres) (sql-user '"username") (sql-password '"password") (sql-database '"rcdbusiness")) (funcall '#f(compiled-function () #<bytecode 0x1e00184608d5>)))
  eval((let ((sql-product ''postgres) (sql-user '"username") (sql-password '"password") (sql-database '"rcdbusiness")) (funcall '#f(compiled-function () #<bytecode 0x1e00184608d5>))))
  #f(compiled-function (conn) #<bytecode -0x99cf3617ae0f94f>)(("local" (sql-product 'postgres) (sql-user "username") (sql-password "password") (sql-database "rcdbusiness")))
  mapcar(#f(compiled-function (conn) #<bytecode -0x99cf3617ae0f94f>) (("local" (sql-product 'postgres) (sql-user "username") (sql-password "password") (sql-database "rcdbusiness"))))
  sql-connection-menu-filter(("--" ["New SQLi Session" sql-product-interactive (sql-get-product-feature sql-product :sqli-comint-func)]))
  #f(compiled-function (menu) #<bytecode 0x10470486be0d08fa>)(("--" ["New SQLi Session" sql-product-interactive (sql-get-product-feature sql-product :sqli-comint-func)]))

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Lars Ingebrigtsen]

Jean Louis <louis@rcdsociety.com> writes:

> - M-x sql-postgres and enter
>
> - then at the exact moment when I click SQL menu, I get this error:
>
> Debugger entered--Lisp error: (error "‘'postgres’ is not a known
> product; use ‘sql-add-product’ to add it first.")
>   signal(error ("‘'postgres’ is not a known product; use
> ‘sql-add-product’ to add it first."))
>   error("`%s' is not a known product; use `sql-add-product' to add it
> first." 'postgres)

[...]

> (("local" (sql-product 'postgres) (sql-user "username") (sql-password
> "password") (sql-database "rcdbusiness"))))
>   sql-connection-menu-filter(("--" ["New SQLi Session"
> sql-product-interactive (sql-get-product-feature sql-product
> :sqli-comint-func)]))

I think this has to mean that your sql-product is set to 'postgres
instead of postgres.

That is, somewhere you have

(setq sql-product ''postgres)

with an extra ' character.  Or perhaps in a defcustom setting.  Is this
the case?

-- 
(domestic pets only, the antidote for overdose, milk.)
   bloggy blog: http://lars.ingebrigtsen.no

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Jean Louis]

* Lars Ingebrigtsen <larsi@gnus.org> [2021-05-13 15:03]:
> Jean Louis <louis@rcdsociety.com> writes:
> 
> > - M-x sql-postgres and enter
> >
> > - then at the exact moment when I click SQL menu, I get this error:
> >
> > Debugger entered--Lisp error: (error "‘'postgres’ is not a known
> > product; use ‘sql-add-product’ to add it first.")
> >   signal(error ("‘'postgres’ is not a known product; use
> > ‘sql-add-product’ to add it first."))
> >   error("`%s' is not a known product; use `sql-add-product' to add it
> > first." 'postgres)
> 
> [...]
> 
> > (("local" (sql-product 'postgres) (sql-user "username") (sql-password
> > "password") (sql-database "rcdbusiness"))))
> >   sql-connection-menu-filter(("--" ["New SQLi Session"
> > sql-product-interactive (sql-get-product-feature sql-product
> > :sqli-comint-func)]))
> 
> I think this has to mean that your sql-product is set to 'postgres
> instead of postgres.
> 
> That is, somewhere you have
> 
> (setq sql-product ''postgres)
> 
> with an extra ' character.  Or perhaps in a defcustom setting.  Is this
> the case?

I am choosing the product by using customize-variable, so the value is
'postgres as symbol.

The same problem I have observed before 4 weeks, but I do not observe
it now. The problem was there when I click with the mouse on SQL menu
item, before the menu item even opens.

I can see that I re-factored the settings and hard-coded it to:

(setq sql-product (quote postgres))

I cannot reproduce it. I don't know why, and I don't see any log of
changes in the git repository. It happened by rule when I clicked on
the "SQL"menu.



Jean

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

Sign an open letter in support of Richard M. Stallman
https://stallmansupport.org/
https://rms-support-letter.github.io/

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Lars Ingebrigtsen]

Jean Louis <bugs@gnu.support> writes:

> I can see that I re-factored the settings and hard-coded it to:
>
> (setq sql-product (quote postgres))

That should be correct; yes.  I'm wondering if you'd earlier had a

(custom-set-variables
 '(sql-product (quote postgres))
 ...)

or similar, which would result in the error you were seeing:

> I cannot reproduce it. I don't know why, and I don't see any log of
> changes in the git repository. It happened by rule when I clicked on
> the "SQL"menu.

But as you can no longer reproduce this bug, I'm closing it.  If it
turns up again later, please respond to the debbugs address and we'll
reopen.

-- 
(domestic pets only, the antidote for overdose, milk.)
   bloggy blog: http://lars.ingebrigtsen.no

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Jean Louis]

* Lars Ingebrigtsen <larsi@gnus.org> [2021-05-16 16:57]:
> > I cannot reproduce it. I don't know why, and I don't see any log of
> > changes in the git repository. It happened by rule when I clicked on
> > the "SQL"menu.
> 
> But as you can no longer reproduce this bug, I'm closing it.  If it
> turns up again later, please respond to the debbugs address and we'll
> reopen.

Just to report that this bug is appearing sometimes, but I cannot
reproduce it.

It appears when I open a new SQL buffer and start doing some
scratch. Problem is that I did not capture or notice what I do that it
appears. 

No need to re-open the bug, I will report when I find the cause.



-- 
Jean

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

Sign an open letter in support of Richard M. Stallman
https://stallmansupport.org/

bug#46061: 28.0.50; error "‘'postgres’ is not a known product

[Benjamin Riefenstahl]

Hi jean,

Jean Louis writes:
> After M-x sql-postgres and clicking on the menu item SQL, I get this
> error:

I can not reproduce this with Emacs compiled from master and executed as
"src/emacs -q".  What else does this need?

> Debugger entered--Lisp error: (error "‘'postgres’ is not a known
> product; use ‘sql-add-product’ to add it first.")
>   signal(error ("‘'postgres’ is not a known product; use ‘sql-add-p..."))

It looks like there is one ' too much in there?  As in (quote 'postgres)
instead of plain 'postgres.

>   #f(compiled-function (menu) #<bytecode 0xfdb21298474a028>)(("--"
>   ["New SQLi Session" sql-product-interactive (sql-get-product-feature
>   sql-product :sqli-comint-func)]))

I do not have this menu item.  When I execute

  M-: (sql-product-interactive
       (sql-get-product-feature sql-product :sqli-comint-func))

that returns fine, result is

  #<window 7 on *SQL: Postgres*>

which is the window object I guess.

benny