Re: [SL] Sql-Ledger 2.6.22/PostgreSQL 8.1.5

[Dirk E. S. <ds...@ca...>]

> Hi,
> I just updated my system with Mandriva 2007 which comes with Postgresql

>
> DBD::Pg::st execute failed: ERROR: column "oid" does not exist
> Error!
> SELECT oid AS oid, qty,
>    (SELECT SUM(qty) FROM inventory
>    WHERE trans_id =3D 10559
>    AND orderitems_id =3D ?) AS total
>    FROM inventory
>    WHERE trans_id =3D 10559
>    AND orderitems_id =3D ?
> ERROR: column "oid" does not exist
>
> What will be the best approach in this case to correct this?

You will have to edit your backups by hand as described in the FAQ:

http://www.sql-ledger.org/cgi-bin/nav.pl?page=3Dmisc/faq.html&title=3DFAQ

Check for the section PostgreSQL 8.0+

Good luck

Enrique

>
> Thanks
> Peter
>




--=20
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com