Re: General Ledger db design - Mailing list pgsql-general

From Karl O. Pinc
Subject Re: General Ledger db design
Date
Msg-id 1172512373l.24168l.2l@mofo
Whole thread Raw
In response to Re: General Ledger db design  (Kenneth Downs <ken@secdat.com>)
List pgsql-general
On 02/26/2007 11:41:18 AM, Kenneth Downs wrote:

>> You can also not allow new rows to be inserted if there
>> is already a batch row, thus the insertion of a
>> batch row "closes" the batch.
>
> Not sure what you mean, but you can in fact have any number of open
> batches, on the assumption that it is a multi-user system.

I'm saying why have a close flag at all?  Why not signal the
close of the batch by the creation of the batch row?

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein


pgsql-general by date:

Previous
From: Kenneth Downs
Date:
Subject: Re: General Ledger db design
Next
From: Magnus Hagander
Date:
Subject: Re: [pgsql-advocacy] PostgreSQL on Windows Paper