check, if ID's are the same on old and new copy your problem may occur when auto increment is enabled You can use tools to export one db to sql and import data to other with strict ID's. phpMyAdmin supports this, maybe there is something for postgres.
Krzysztof Podejma 2007/11/27, Vince M. Clark <[EMAIL PROTECTED]>: > > We have a really strange thing happening when restoring a database from a > dump file. One of our promotions doesn't work as it did before. Nothing has > changed. I can go to the old database from where we dumped the data and the > promo works fine. I run pg_dump, restore the database to another server, and > the very same promotion only partially works. It is a quantity discount that > discounts the 2nd, 3rd, 4th, and 5th quantities of an item on an order. What > is strange is that it correctly discounts quantities of 2 or 4, but not 3. > > The only difference I can see in the data is that the promo actions were > loaded in the oposite order from the original database. We are running > against the same codebase. > > > Vince Clark > Global Era > The Freedom of Open Source > [EMAIL PROTECTED] > (303) 493-6723 >
