GnuCash PostgreSQL support

[Derek Atkins]

Hi,

On Sat, January 28, 2012 12:04 pm, Tarlika Elisabeth Schmitz wrote:
> On Fri, 27 Jan 2012 14:31:23 -0800
> John Ralls <jralls at ceridwen.us> wrote:
>>>>
>>>> On Jan 27, 2012, at 7:48 AM, Tarlika Elisabeth Schmitz wrote:
>>>>
>>> What I would like to do is creating a few
>>> more expense subcategories. For example, I have lumped all Household
>>> expenses into Expenses.Household.
>>>
>>> I'd like to refine this:
>>> Expenses.Household.Heating
>>> Expenses.Household.Food
>>> Expenses.Household.Electricity
>>>
>>> This would only require changing the guid of one <split:account>
>>> element as far as I can see (based on my notes field).
>>Except that the running account balance is part of the split's state,
>>and is maintained by xaccTransactionCommitEdit() and
>>xaccSplitCommitEdit() in the Engine. If you change the account guid
>>outside of the engine, the balances in the affected accounts will be
>>messed up. Running Check and Repair *might* put them right, so you
>>could try it on copy of your DB and see if it works out.
>
> Is the balance stored in the file/DB? I didn't see it looking at my xml
> file.

No, the balances are all computed at runtime, because GnuCash has all
transactional data in memory.  This way if you DO make a change in the
past all your balances will be corrected instantly without requiring data
changes.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant