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/