The SQL for PostgreSQL under the Decimal Inventory changes (r1902) didn't work for me until I added 'type' before 'numeric'. Here's the full code I ended up using:
alter table product_price alter column quantity type numeric(18,6); alter table product_product alter column items_in_stock type numeric (18,6); alter table product_product alter column total_sold type numeric (18,6); alter table product_productpricelookup alter column items_in_stock type numeric(18,6); alter table product_productpricelookup alter column quantity type numeric(18,6); alter table shop_cartitem alter column quantity type numeric(18,6); alter table shop_orderitem alter column quantity type numeric(18,6); alter table supplier_rawitem alter column inventory type numeric (18,6); alter table tieredpricing_tieredprice alter column quantity type numeric(18,6); alter table tieredquantity_quantitytier alter column quantity type numeric(18,6); I don't know if that's required for all postgre versions, but hopefully it's helpful for others. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en -~----------~----~----~----~------~----~------~--~---
