Re: [SL] Upgrade problem

[Adrian B. <adr...@ie...>]

Progress:

the error is now:

DBD::Pg::st execute failed: ERROR: column t.validto does not exist
.
.
.

ERROR: column t.validto does not exist

I should add, I had a hard disk crash but I could do a pg_dumpall & SQL-Ledger is the only database. I have had to upgrade from 
postgres 7.? to 8.1.?

Adrian

Dieter Simader wrote:
> edit the backup you made with SQL-Ledger,
> change the tables orderitems, inventory and assembly and add 'WITH OIDS'
> (see the FAQ)
> restore the backup with psql
> 
> psql -U sql-ledger dbname < backup.sql
> 

-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph. 02 80042212  mobile 0407 232 978

http://150.101.125.30