I don't know the answer to any of these, but I should add that the Business objects don't with with SQL. In fact, the SQL backend has bitrotted a bit in CVS to the point where a I think a lot of the new functionality is not supported by the SQL backend.
Indeed, none of the active developers actually understand the SQL backend... We'd love to find someone who cares enough to keep it updated. Any volunteers? -derek Nicholas Lee <[EMAIL PROTECTED]> writes: > Couples issues with the postgres backend using the cvs version of > gnucash. > > Seem when starting a new database that i) gnucash postgres driver (GPD) > can't CREATE DATABASEs, at least creating them by hand (createdb) fixes > the first connection error. ii) Tries to double CREATE TABLE when first > initialising a db: > > Aug 22 23:19:18 lode postgres[27655]: [2] NOTICE: CREATE TABLE / UNIQUE will create >implicit index 'gncversion_name_key' for table 'gncversion' > Aug 22 23:19:21 lode postgres[27656]: [1] DEBUG: connection: host=192.168.98.88 >user=plumtree database=template1 > Aug 22 23:19:21 lode postgres[27657]: [1] DEBUG: connection: host=192.168.98.88 >user=plumtree database=plumtree-accounts > Aug 22 23:19:21 lode postgres[27657]: [2] NOTICE: CREATE TABLE / UNIQUE will create >implicit index 'gncversion_name_key' for table 'gncversion' > Aug 22 23:19:21 lode postgres[27657]: [3] ERROR: Relation 'gncversion' already >exists > > I was able to get around this my DROPing 'gncversion' while gnucash > waited at the 'you want to create a new db' dialog. > > > iii) while trying to insert data from my company accounts (800kb book) > it crashed with this error: > > Aug 22 23:24:42 lode postgres[27714]: [14] ERROR: Bad timestamp external >representation '2000-12-04 00:00:00.000000 +1300' > > Any suggestions as too the reason for this? > > Nicholas > > > _______________________________________________ > gnucash-devel mailing list > [EMAIL PROTECTED] > http://www.gnucash.org/cgi-bin/mailman/listinfo/gnucash-devel -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH [EMAIL PROTECTED] PGP key available _______________________________________________ gnucash-devel mailing list [EMAIL PROTECTED] http://www.gnucash.org/cgi-bin/mailman/listinfo/gnucash-devel
