[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