When I try to install a new database after upgrading, I now get errors. I had
it working earlier with 1.3.11, so it's a bit curious:
Apr 5 22:37:12 limelight postgres[86551]: [2-1] FATAL: database "ledgertest"
does not exist
Apr 5 22:37:23 limelight postgres[86562]: [2-1] ERROR: language "plpgsql"
already exists
Apr 5 22:37:23 limelight postgres[86562]: [2-2] STATEMENT: CREATE LANGUAGE
PLPGSQL;
Apr 5 22:37:52 limelight postgres[86601]: [2-1] ERROR: type in_recon_fx does
not exist
Apr 5 22:37:52 limelight postgres[86601]: [2-2] STATEMENT: CREATE OR REPLACE
FUNCTION reconciliation__new_report_id
Apr 5 22:37:52 limelight postgres[86601]: [2-3] (in_chart_id int,
in_total numeric, in_end_date date, in_recon_fx) returns INT as $$
Apr 5 22:37:52 limelight postgres[86601]: [2-4]
Apr 5 22:37:52 limelight postgres[86601]: [2-5] INSERT INTO
cr_report(chart_id, their_total, end_date, recon_fx)
Apr 5 22:37:52 limelight postgres[86601]: [2-6] values ($1, $2, $3,
$4);
Apr 5 22:37:52 limelight postgres[86601]: [2-7] SELECT
currval('cr_report_id_seq')::int;
Apr 5 22:37:52 limelight postgres[86601]: [2-8]
Apr 5 22:37:52 limelight postgres[86601]: [2-9] $$ language 'sql';
Apr 5 22:37:52 limelight postgres[86601]: [3-1] ERROR: current transaction is
aborted, commands ignored until end of transaction block
And then pages and pages of errors, since it does not stop trying after the
first failure.
Any clues?
------------------------------------------------------------------------------
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-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel