GNU bug report logs - #46061
28.0.50; error "‘'postgres’ is not a known product

Previous Next

To add a comment to this bug, you must first unarchive it, by sending
a message to control AT debbugs.gnu.org, with unarchive 46061 in the body.
You can then email your comments to 46061 AT debbugs.gnu.org in the normal way.

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: 28.0.50; error "‘'postgres’ is not a known
 product
Date: Sun, 24 Jan 2021 02:55:19 +0300

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
⎔ λ 🄯 𝍄 𝌡 𝌚

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

From: Lars Ingebrigtsen <larsi <at> gnus.org>
To: Jean Louis <bugs <at> gnu.support>
Cc: 46061 <at> debbugs.gnu.org
Subject: Re: bug#46061: 28.0.50; error "‘'postgres’
 is not a known product
Date: Sun, 24 Jan 2021 22:30:45 +0100

Jean Louis <bugs <at> 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

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

From: Benjamin Riefenstahl <b.riefenstahl <at> turtle-trading.net>
To: Jean Louis <bugs <at> gnu.support>
Cc: 46061 <at> debbugs.gnu.org
Subject: Re: bug#46061: 28.0.50; error "‘'postgres’
 is not a known product
Date: Mon, 25 Jan 2021 18:27:37 +0100

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

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

From: Lars Ingebrigtsen <larsi <at> gnus.org>
To: Jean Louis <bugs <at> gnu.support>
Cc: 46061 <at> debbugs.gnu.org
Subject: Re: bug#46061: 28.0.50; error "‘'postgres’
 is not a known product
Date: Mon, 01 Mar 2021 16:17:18 +0100

Lars Ingebrigtsen <larsi <at> gnus.org> writes:

> Jean Louis <bugs <at> 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

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

From: Jean Louis <bugs <at> gnu.support>
To: Lars Ingebrigtsen <larsi <at> gnus.org>
Cc: 46061 <at> debbugs.gnu.org
Subject: Re: bug#46061: 28.0.50; error "‘'postgres’ is not a known product
Date: Sun, 14 Mar 2021 11:32:33 +0300

* Lars Ingebrigtsen <larsi <at> gnus.org> [2021-01-25 00:31]:
> Jean Louis <bugs <at> 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.

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

From: Lars Ingebrigtsen <larsi <at> gnus.org>
To: Jean Louis <bugs <at> gnu.support>
Cc: 46061 <at> debbugs.gnu.org
Subject: Re: bug#46061: 28.0.50; error "‘'postgres’
 is not a known product
Date: Tue, 16 Mar 2021 01:26:10 +0100

Jean Louis <bugs <at> 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

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

From: Rudolf Schlatte <rudi <at> constantly.at>
To: bug-gnu-emacs <at> gnu.org
Subject: Re: bug#46061: 28.0.50; error "‘'postgres’
 is not a known product
Date: Tue, 16 Mar 2021 09:53:31 +0100

Lars Ingebrigtsen <larsi <at> gnus.org> writes:

> Jean Louis <bugs <at> 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.)

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

From: Jean Louis <louis <at> rcdsociety.com>
To: Rudolf Schlatte <rudi <at> constantly.at>
Cc: 46061 <at> debbugs.gnu.org
Subject: Re: bug#46061: 28.0.50; error "‘'postgres’ is not a known product
Date: Thu, 8 Apr 2021 16:22:08 +0300

* Rudolf Schlatte <rudi <at> constantly.at> [2021-03-16 11:54]:
> Lars Ingebrigtsen <larsi <at> gnus.org> writes:
> 
> > Jean Louis <bugs <at> 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)]))

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

From: Lars Ingebrigtsen <larsi <at> gnus.org>
To: Jean Louis <louis <at> rcdsociety.com>
Cc: 46061 <at> debbugs.gnu.org, Rudolf Schlatte <rudi <at> constantly.at>
Subject: Re: bug#46061: 28.0.50; error "‘'postgres’
 is not a known product
Date: Thu, 13 May 2021 14:02:48 +0200

Jean Louis <louis <at> 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

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

From: Jean Louis <bugs <at> gnu.support>
To: Lars Ingebrigtsen <larsi <at> gnus.org>
Cc: 46061 <at> debbugs.gnu.org, Rudolf Schlatte <rudi <at> constantly.at>
Subject: Re: bug#46061: 28.0.50; error "‘'postgres’ is not a known product
Date: Thu, 13 May 2021 18:28:46 +0300

* Lars Ingebrigtsen <larsi <at> gnus.org> [2021-05-13 15:03]:
> Jean Louis <louis <at> 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/

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

From: Lars Ingebrigtsen <larsi <at> gnus.org>
To: Jean Louis <bugs <at> gnu.support>
Cc: 46061 <at> debbugs.gnu.org, Rudolf Schlatte <rudi <at> constantly.at>
Subject: Re: bug#46061: 28.0.50; error "‘'postgres’
 is not a known product
Date: Sun, 16 May 2021 15:56:16 +0200

Jean Louis <bugs <at> 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

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

From: Jean Louis <bugs <at> gnu.support>
To: Lars Ingebrigtsen <larsi <at> gnus.org>
Cc: 46061 <at> debbugs.gnu.org, Rudolf Schlatte <rudi <at> constantly.at>
Subject: Re: bug#46061: 28.0.50; error "‘'postgres’ is not a known product
Date: Sat, 5 Jun 2021 19:11:26 +0300

* Lars Ingebrigtsen <larsi <at> 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/

Previous Next

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