Never tracked down whether it was a postgres issue or not. We re-created the promotions and they worked.
----- Original Message ----- From: "Krzysztof Podejma" <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, November 28, 2007 9:07:17 AM (GMT-0700) America/Denver Subject: Re: Postgres dump/restore - our promotions are broken! ??? 2007/11/27, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > > I would love to know how to pronounce Krzysztof. > > Skip > > -----Original Message----- > From: Krzysztof Podejma [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 27, 2007 7:57 AM > To: [email protected] > Subject: Re: Postgres dump/restore - our promotions are broken! > > > 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 > > > >
