Phil Longstaff wrote: > Mark Johnson wrote: > >> Using: SVN 16836 gda-dev2 branch. >> Postgresql 8.2.6 >> >> 1. start gnucash with --nofile option >> 2. open read-only copy of existing xml file. >> >> > I assume you mean this was with the "Open file" dialog. Hmmm... I'll > look at this (see below). > Yes. >> 3. At this point, the accounts window opens and NO accounts are >> displayed. If I understand Phil's post correctly, I should have had >> accounts here, but with unreliable balance information. >> >> > The fact that there were no accounts combined with #7 below seem to > indicate that it didn't load your existing xml file, but instead created > a new sqlite file. > > For clarifications, if you load from an xml file, the account balances > should be correct. If you load from a db, the balances may be 0.00. > It seems to have created both the SQLite file and the Postgresql db. Perhaps, this is related to the performance issue you had mentioned when saving.
I am also using the latest (unstable) version of libgda (3.1.2). In response to your latest e-mail, here is the excerpt from /tmp/gnucash.trace: * 22:17:29 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8452c70 VND into nsp=0x8260fa0 CURRENCY * 22:17:29 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8452d88 YER into nsp=0x8260fa0 CURRENCY * 22:17:29 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8452d28 YUM into nsp=0x8260fa0 CURRENCY * 22:17:29 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8451b20 ZMK into nsp=0x8260fa0 CURRENCY * 22:17:29 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8451be0 ZWD into nsp=0x8260fa0 CURRENCY * 22:17:29 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8451b58 XDR into nsp=0x8260fa0 CURRENCY * 22:17:29 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x844e620 XXX into nsp=0x8260fa0 CURRENCY * 22:17:29 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8451d78 XAU into nsp=0x8260fa0 CURRENCY * 22:17:29 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8451e90 XPD into nsp=0x8260fa0 CURRENCY * 22:17:29 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8451e40 XPT into nsp=0x8260fa0 CURRENCY * 22:17:29 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8451f48 XAG into nsp=0x8260fa0 CURRENCY * 22:17:29 INFO <qof.session> [qof_session_load_backend] selected GnuCash LibGDA Backend * 22:17:50 INFO <qof.session> [qof_session_begin] Done running session_begin on backend * 22:17:50 INFO <gnc.gui> [gnc_post_file_open] logpath=/mnt/raid/home/mj/.gnucash/data/books_copy_2008-01-14.xac * 22:17:50 INFO <gnc.account> [xaccAccountRecomputeBalance] acct= starting baln=0/1 * 22:17:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x845d2d0 AFA into nsp=0x8649440 CURRENCY * 22:17:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8458468 AFN into nsp=0x8649440 CURRENCY * 22:17:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x84561e8 ALL into nsp=0x8649440 CURRENCY * 22:17:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x844d028 DZD into nsp=0x8649440 CURRENCY * 22:17:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x845b160 ADF into nsp=0x8649440 CURRENCY * 22:17:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x84460b0 ADP into nsp=0x8649440 CURRENCY * 22:17:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x843f490 AON into nsp=0x8649440 CURRENCY * 22:17:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x845b3e8 ARA into nsp=0x8649440 CURRENCY * 22:17:50 INFO <gnc.commodity> [gnc_commodity_table_insert] insert 0x8444098 ARS into nsp=0x8649440 CURRENCY The qof_session_load_backend did not appear in the file until after I tried to open the xml file (using File->Open). The lines before and after this excerpt seem to be much more of the same - loading commodities. Mark _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
