Re: Trouble converting database

[Jos Geluk <..hidden..>]

Erik Huelsmann <..hidden..> wrote:

> Could you try with version 1.3.14? At some stage the excess LANGUAGE
> PLPGSQL has been removed on the 1.3 branch and it's no longer in 1.3.14
> which should solve at least that problem.

Thank you for replying, but no, this doesn't help. I get a slightly 
different set of error messages:

2012-04-10 12:48:47 CEST ERROR:  column "version" does not exist at 
character 8
2012-04-10 12:48:47 CEST STATEMENT:  SELECT version FROM defaults
2012-04-10 12:49:28 CEST ERROR:  language "plpgsql" already exists
2012-04-10 12:49:28 CEST STATEMENT:  CREATE LANGUAGE PLPGSQL;
2012-04-10 12:50:12 CEST ERROR:  type in_recon_fx does not exist
2012-04-10 12:50:12 CEST STATEMENT:  CREATE OR REPLACE FUNCTION 
reconciliation__new_report_id
	(in_chart_id int, in_total numeric, in_end_date date, in_recon_fx) 
returns INT as $$
	
	    INSERT INTO cr_report(chart_id, their_total, end_date, recon_fx)
	    values ($1, $2, $3, $4);
	    SELECT currval('cr_report_id_seq')::int;
	
	$$ language 'sql';
2012-04-10 12:50:12 CEST ERROR:  current transaction is aborted, 
commands ignored until end of transaction block

Whereas
SELECT * FROM defaults WHERE setting_key='version'
confirms me that it is version 1.3.14.

Any other ideas?

Jos.

-- 
www.ardispark.nl
tel. 06 5341 4670

------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users