[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Problems installing on PostgreSQL 9.1 after upgrading to 1.3.14



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?