Re: octave-database - data entry into database table

[richard]

On Mon, Feb 11, 2013 at 10:27:58AM +0100, c. wrote:
> 
> > I did install the new version. I seem to have permission problems 
> > with that (or something similar,)
> 
> What version of Octave are you using?
GNU Octave, version 3.6.2
> On what system?
Octave was configured for "x86_64-pc-linux-gnu".
I'm running Debian|testing on an AMD based SMP system  
> What are the commands you tried to install the package?
(from memory, and as root)
octave > pkg install ./database-2.0.0.tar.gz 
As far as I could tell, the package installed correctly
and the directory appeared alongside the previous directory
> What exactly is the error you got?
I cannot remember which commands I tried as user, but the 
system did not seem to respond. I doubt there is a bug, 
just a newbie learning curve to transit. 

[BTW in answer to a separate query, ralough at iee.org 
is valid and should be a more robust address]

====================================================
I had a similar problem with this code: 
postgres
default_db(postgres_db("host=localhost dbname=rome user=user password='secret' 
"));
S=sql("select * from rome001;");
for j = 1:330 x(j) = S(j,1) ; endfor
for j = 1:330 y1(j) = S(j,2) ; endfor
for j = 1:330 y2(j) = S(j,5) ; endfor

unless "postgres" is declared first, octave cannot find "default_db".
If there are examples of how to use the new version of "database,"
I am still looking for them. 

I will mention something that I am currently trying to sort out as 
this is likely to recur in the new version. If I run this: 

S = load( "-ascii", "./rome.csv");
for j = 1:330 x(j) = S(j,1) ; endfor
for j = 1:330 y1(j) = S(j,2) ; endfor
for j = 1:330 y2(j) = S(j,5) ; endfor

The results differ: in the first instance I get a column matrix for y1
and in the second y1 is a single row. While I could change rows and 
columns in the database in this example, it is not practical for 
larger datasets. 

TIA

Richard