[Advacs-discuss] Now able to post journal entries
Oliver Elphick
olly@lfix.co.uk
Tue, 12 Oct 2004 12:09:08 +0100
On Mon, 2004-10-11 at 09:21, Oliver Elphick wrote:
> As a result of the latest debugging changes, it is now possible to post
> journal entries in the General ledger by inserts to the journal view.
> (There's a long way to go yet, though.)
>
> Please test the installation and let me know of any problems.
It seems that this _requires_ PostgreSQL 8.0. I conducted the tests on
that and now find it won't do the insert in 7.4.5:
INSERT INTO journal (yearend, subpd, line_cnt, ref, currency,
ldg_codes,depts, accounts, dates, amounts, lrefs, narratives) VALUES
('31 Mar 2004',1,2,'TEST2','GBP',ARRAY ['GL','GL'],ARRAY
['LF','LF'],ARRAY ['SHAREORD','PANDL'],ARRAY['1 Apr 2003'::DATE,'1 Apr
2003'::DATE],ARRAY [2713.0,-2713.00],ARRAY ['A1','A2'],ARRAY ['Narrative
1','Narrative 2']);
ERROR: cannot handle whole-row reference
Since I'm targetting PG 8, that is not a serious problem, but testers
need to be aware of it.
--
Oliver Elphick olly@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"Blessed is the man who makes the LORD his trust,
who does not look to the proud, to those who turn
aside to false gods." Psalms 40:4