postgres backend

Derek Atkins warlord@MIT.EDU
22 Aug 2002 10:22:30 -0400


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 <nj.lee@plumtree.co.nz> 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
> gnucash-devel@lists.gnucash.org
> https://lists.gnucash.org/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
       warlord@MIT.EDU                        PGP key available