All,

I've been using Gnucash for a long time and have grown to like it. I've
heard for a long time about how it is possible to tie Gnucash into the
PostgreSQL database. I have a running instance of PostgreSQL which I use
for several other applications, so when I installed Fedora on my main box,
I thought I'd try this out.

I installed both the gnucash RPM (1.8.8) and the
gnucash-backend-postgres RPM. I then opened my existing Gnucash file with
a year or so worth of transactions. Looking at the documentation on the
SQL HOWTO (http://www.gnucash.org/en/sql.phtml) Gnucash site, I used a
"save as" function to write the data to the database.

I ran into errors while saving the file. If I used the either the
default multi-user or single-update mode, Gnucash will correctly create and
populate the tables for all the accounts, but as soon as it tries to add
the individual transactions, it barfs with an error to the effect:

Error: pgendAccountGetPartialBala...(): send query failed:
another command is already in progress

After exiting and re-starting Gnucash, it will correctly open the
database and read in all the accounts, but they are all empty. In fact, if
I add new transactions (effectively starting over again from scratch), it
will correctly save those transactions, but of the previous ones from the
existing file.

Is there any way to create a FULLY POPULATED database from an existing
Gnucash file? What am I missing???

--
Chuck Tryon
chucktryon@yahoo.com