Re: [SL] Upgrade problem

[Dieter S. <dsi...@sq...>]

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

-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================

On Tue, 28 Nov 2006, Adrian Blake wrote:

> I was forced to do an upgrade and now have the following error:
>
> DBD::Pg::st execute failed: ERROR: column o.oid does not exist
> .
> .
> .
>
> ERROR: column o.oid does not exist
>
>
> The FAQ has the following :Drop the tables and rebuild WITH OIDS
>
> I have my O'Reilly " Practical PostgreSQL" handy, but still do not understand how to "Drop the tables and rebuild WITH OIDS"
>
> Adrian
>