Erik Huelsmann <ehu...@gmail.com> 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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
