Graham Menhennitt wrote: > Mark Johnson wrote: > >> Graham Menhennitt wrote: >> >>> Phil Longstaff wrote: >>> >>> >>>> Graham Menhennitt wrote: >>>> >>>> >>>>> saved. I then try to load from the DB using a command line >>>>> parameter of >>>>> the DSN. It runs for a few seconds and then crashes with a >>>>> segmentation >>>>> violation. >>>>> >>>> I just committed rev 16942 which should fix this. I don't use the >>>> business objects, so please exercise them. >>>> >>> Yes, that fixed it, thanks. I still get a message when it starts saying >>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >>> "billterms_pkey" for table "billterms" >>> but my data seems to load correctly. Note that I don't actually have any >>> billing terms in my data. >>> >>> I'll do some more testing. >>> >>> Thanks, >>> Graham >>> >>> >>> >> The notice is normal PostgreSQL output. It means that when you create >> a primary key, it implicitly creates an index. I expect that the >> purpose of the message is to inform the user of the name of that index >> object, as the existence of the index to support the primary key is >> necessary. >> >> > Agreed. But why does it happen on re-opening the database? Why wasn't it > created when the database was originally created? Actually, looking back > through my xterm output, it's been "created" twice - once when the > original database was created and once when it was re-opened... > > > $ gnucash finance > > > This is a development version. It may or may not work. > Report bugs and other problems to [EMAIL PROTECTED] > You can also lookup and file bug reports at http://bugzilla.gnome.org > The last stable version was GnuCash 2.2.2 > The next stable version will be GnuCash 2.4 > > Found Finance::Quote version 1.13 > Error: xaccOpenLog(): cannot open journal > 2 No such file or directory > Implementation missing: database_constraints_update_list() in > gda-dict-database.c line 1214 > Implementation missing: database_constraints_update_list() in > gda-dict-database.c line 1214 > Implementation missing: database_constraints_update_list() in > gda-dict-database.c line 1214 > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "customers_pkey" for table "customers" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "jobs_pkey" for table "jobs" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "transactions_pkey" for table "transactions" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "splits_pkey" for table "splits" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "lots_pkey" for table "lots" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "budgets_pkey" for table "budgets" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "taxtables_pkey" for table "taxtables" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "taxtable_entries_pkey" for table "taxtable_entries" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "recurrences_pkey" for table "recurrences" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "employees_pkey" for table "employees" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "orders_pkey" for table "orders" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "commodities_pkey" for table "commodities" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "accounts_pkey" for table "accounts" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "slots_pkey" for table "slots" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "schedxactions_pkey" for table "schedxactions" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "invoices_pkey" for table "invoices" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "prices_pkey" for table "prices" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "entries_pkey" for table "entries" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "vendors_pkey" for table "vendors" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "books_pkey" for table "books" > Implementation missing: database_constraints_update_list() in > gda-dict-database.c line 1214 > Implementation missing: database_constraints_update_list() in > gda-dict-database.c line 1214 > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "customers_pkey" for table "customers" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "jobs_pkey" for table "jobs" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "transactions_pkey" for table "transactions" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "splits_pkey" for table "splits" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "lots_pkey" for table "lots" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "budgets_pkey" for table "budgets" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "taxtables_pkey" for table "taxtables" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "taxtable_entries_pkey" for table "taxtable_entries" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "recurrences_pkey" for table "recurrences" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "employees_pkey" for table "employees" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "orders_pkey" for table "orders" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "commodities_pkey" for table "commodities" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "accounts_pkey" for table "accounts" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "slots_pkey" for table "slots" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "schedxactions_pkey" for table "schedxactions" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "billterms_pkey" for table "billterms" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "invoices_pkey" for table "invoices" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "prices_pkey" for table "prices" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "entries_pkey" for table "entries" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "vendors_pkey" for table "vendors" > Implementation missing: database_constraints_update_list() in > gda-dict-database.c line 1214 > Implementation missing: database_constraints_update_list() in > gda-dict-database.c line 1214 > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "customers_pkey" for table "customers" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "jobs_pkey" for table "jobs" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "transactions_pkey" for table "transactions" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "splits_pkey" for table "splits" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "lots_pkey" for table "lots" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "budgets_pkey" for table "budgets" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "taxtables_pkey" for table "taxtables" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "taxtable_entries_pkey" for table "taxtable_entries" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "recurrences_pkey" for table "recurrences" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "employees_pkey" for table "employees" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "orders_pkey" for table "orders" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "commodities_pkey" for table "commodities" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "accounts_pkey" for table "accounts" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "slots_pkey" for table "slots" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "schedxactions_pkey" for table "schedxactions" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "invoices_pkey" for table "invoices" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "prices_pkey" for table "prices" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "entries_pkey" for table "entries" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "vendors_pkey" for table "vendors" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "books_pkey" for table "books" > Implementation missing: database_constraints_update_list() in > gda-dict-database.c line 1214 > $ gnucash gda://@ggg > > > This is a development version. It may or may not work. > Report bugs and other problems to [EMAIL PROTECTED] > You can also lookup and file bug reports at http://bugzilla.gnome.org > The last stable version was GnuCash 2.2.2 > The next stable version will be GnuCash 2.4 > > Found Finance::Quote version 1.13 > Implementation missing: database_constraints_update_list() in > gda-dict-database.c line 1214 > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "billterms_pkey" for table "billterms" > Implementation missing: database_constraints_update_list() in > gda-dict-database.c line 1214 > > > The above should have gone to the list as well.
Phil, it seems to be creating billterms on the second run each time. I've seen this too, but I had thought when I saw this that it had something to do with my using a new SVN of gnucash. I guess that was wrong. Also, it looks like you get two notices for each table. Did you do the "Database connection" twice? Either way it's a problem. If you did save to the DB twice, gnucash-gda should have detected that there was already data there and refused to wipe it. (Already noted in another post.) If you didn't save twice, then gnucash-gda is doing something redundant. Mark _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
