[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Problems installing on PostgreSQL 9.1 after upgrading to 1.3.14
- Subject: Problems installing on PostgreSQL 9.1 after upgrading to 1.3.14
- From: Mikkel Høgh <..hidden..>
- 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?