Test sql functionality

Linas Vepstas linas@linas.org
Mon, 25 Jun 2001 09:57:27 -0500


On Mon, Jun 25, 2001 at 09:44:57AM -0500, Linas Vepstas was heard to remark:
> Chris,
> 
> Thanks for all your efforts,
> 
> On Sun, Jun 24, 2001 at 08:49:45PM -0700, Chris Lyttle was heard to remark:
> > Linas,
> > I did some more testing and ran a few sql commands to look at the actual
> > db I created. It seems that if I create a db and then add new accounts
> > it works fine to add them. If I try to save an already existing account
> > (convert it from the flat text file to the db) it creates the db but
> > doesn't save anything apart from the table names. I tried to resave the
> > file to the db after I had created it with the same result, no data
> > saved. 
> 
> You still have not replied to me in the affirmative that you have tried 
> the one thing I suggested a while ago:
> 
> > > > > Due to a bug in 1.6.0 (which I fixed recently), you need to save as 
> > > > > 
> > > > > postgres://localhost/somenewname?mode=single-user-update

Argh, that's a typo !!
Should be

postgres://localhost/somenewname?mode=single-update

> 
> Indeed, the trace that you just sent me shows that you are *not* 
> using this URL:
> 
> > Enter: gnc_book_begin:  ignore_lock=0, book-id=postgres://localhost/newaccounts
> 
> 
> -- 
> Linas Vepstas -- linas@gnumatic.com -- http://www.gnumatic.com/