Message info
 
To:Development discussion for LedgerSMB From:Mikkel H√łgh Subject:[Ledger-smb-devel] Problems installing on PostgreSQL 9.1 after upgrading to 1.3.14 Date:Thu, 5 Apr 2012 22:43:54 +0200
 

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
Ledger-smb-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel