bugGNU Octave - Bugs: bug #57124, [octave forge] (database)...

 
 

bug #57124: [octave forge] (database) pg_connect is undefined when attempting to connect to a database

Submitter:  richard <r1chard>
Submitted:  Sun 27 Oct 2019 10:11:05 PM UTC
   
 
Category:  Octave Package Severity:  3 - Normal
Priority:  5 - Normal Item Group:  Unexpected Error or Warning
Status:  Works For Me Assigned to:  None
Originator Name:  r1chard Open/Closed:  * Closed
Release:  * 5.1.0 Operating System:  * GNU/Linux
Fixed Release:  None Planned Release:  None
* Mandatory Fields

Add a New Comment Rich Markup
   

Mon 28 Oct 2019 08:49:08 PM UTC, comment #4: 

comment #3:

> You need to install database-2.4.4 in order to get it to compile on 5.1


OK, I downloaded the database-2.4.4 and ran pkg install on 5.1

I got a bunch of warning messages, but the install did finish.

I attach a copy of that output in case it is useful.

And my octave/pg code is back to running

many thanks


(file #47762)

richard <r1chard>
Mon 28 Oct 2019 08:14:53 PM UTC, comment #3: 

You need to install database-2.4.4 in order to get it to compile on 5.1

John Donoghue <lostbard>
Group Member
Mon 28 Oct 2019 07:46:52 PM UTC, comment #2: 

Thanks Mike, unfortunately, the (re-)install threw a crash
I'll just add a correction to my original post - the Debian version is testing which I think is Bullseye.

Prior to receiving your email, I reverted to octave 4.4.1 and that ran.

I re-ran install, this time under script to grab a copy of the output, hopefully that file is attached and readable

(file #47761)

richard <r1chard>
Mon 28 Oct 2019 06:02:31 PM UTC, comment #1: 

Thanks for your bug report. Since database is installed by 'pkg', versus all the other packages you have listed, I suspect you simply need to reinstall the package. When a package is installed, it typically only works with that major version of Octave. When your system upgraded from Octave 4.4 to 5.1, the database package needs to be rebuilt / reinstalled. Please try that and comment again if there are still problems.

Mike Miller <mtmiller>
Group Member
Sun 27 Oct 2019 10:11:05 PM UTC, original submission:  

I'm running Debian|Buster (Stable)
the installed version of octave is (5.1.0-3).
pkg list is
Package Name         | Version | Installation directory
---------------------+---------+-----------------------
           database  |   2.4.3 | /home/richard/octave/database-2.4.3
       econometrics  |   1.1.2 | /usr/share/octave/packages/econometrics-1.1.2
fuzzy-logic-toolkit  |   0.4.5 | /usr/share/octave/packages/fuzzy-logic-toolkit-0.4.5
            general  |   2.1.0 | /usr/share/octave/packages/general-2.1.0
                 io  |  2.4.12 | /usr/share/octave/packages/io-2.4.12
              optim  |   1.6.0 | /usr/share/octave/packages/optim-1.6.0
           parallel  |   3.1.3 | /usr/share/octave/packages/parallel-3.1.3
         statistics  |   1.4.1 | /usr/share/octave/packages/statistics-1.4.1
             struct  |  1.0.16 | /usr/share/octave/packages/struct-1.0.16

I am running postgresql 11 and various perl programs run ok with that.
libpq5 and libpg-dev are installed  (12.0-1+b1)

I usually run the commandline version of octave : octage --no-gui
and I note that the gui is no longer appearing if I simply type octave

I last ran an octave database application a month ago under octave version 4.4.1.
Since then, the Debian distribution was upgraded, hence a large number of programs were updated.
My application now fails at the line
  conn = pq_connect (setdbopts ("host", "localhost", "dbname", "euro02", "user", "richard", "password", "xxxxxxxx"));

the reply is
error: '__pq_connect__' undefined near line 112 column 10

I suspect that acceptable formats for pg_connect have changed, and pending advice on what to do, I'll try changing the format
of that line

richard <r1chard>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

Attached Files
file #47762:  octave.5.database.pkg.install2.scr added by r1chard (11KiB - application/x-silverlight)
file #47761:  octave.5.database.pkg.install.scr added by r1chard (13KiB - application/x-silverlight)

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by lostbard (Posted a comment)
  • -email is unavailable- added by r1chard (Submitted the item)
  • -email is unavailable- added by r1chard
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only group members can vote.

     

    Follow 8 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2019-10-28 mtmiller StatusNeed Info Works For Me
        Open/ClosedOpen Closed
    2019-10-28 r1chard Attached File- Added octave.5.database.pkg.install2.scr, #47762
    2019-10-28 r1chard Attached File- Added octave.5.database.pkg.install.scr, #47761
    2019-10-28 mtmiller CategoryLibraries Octave Package
        StatusNone Need Info
        Summarypg_connect is undefined when attempting to connect to a database [octave forge] (database) pg_connect is undefined when attempting to connect to a database
    2019-10-27 r1chard Carbon-Copy- Added -email is unavailable-

    Back to the top

    Powered by Savane 3.13-f8d8.
    Corresponding source code