postgres backend

[Nicholas Lee]

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