Postgres dump/restore - our promotions are broken!

[Vince Clark]

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
[hidden email]
[phone]

[Krzysztof Podejma]

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 <[hidden email]>:

>
> 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
> [hidden email]
> [phone]
>

[SkipDever]

I would love to know how to pronounce Krzysztof.

Skip

-----Original Message-----
From: Krzysztof Podejma [mailto:[hidden email]]
Sent: Tuesday, November 27, 2007 7:57 AM
To: [hidden email]
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 <[hidden email]>:
>
> 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
> [hidden email]
> [phone]
>

[Krzysztof Podejma]

???

2007/11/27, skip@thedevers <[hidden email]>:

>
> I would love to know how to pronounce Krzysztof.
>
> Skip
>
> -----Original Message-----
> From: Krzysztof Podejma [mailto:[hidden email]]
> Sent: Tuesday, November 27, 2007 7:57 AM
> To: [hidden email]
> 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 <[hidden email]>:
> >
> > 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
> > [hidden email]
> > [phone]
> >
>
>

[Vince Clark]

Never tracked down whether it was a postgres issue or not. We re-created the promotions and they worked.

----- Original Message -----
From: "Krzysztof Podejma" <[hidden email]>
To: [hidden email]
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, skip@thedevers <[hidden email]>:

>
> I would love to know how to pronounce Krzysztof.
>
> Skip
>
> -----Original Message-----
> From: Krzysztof Podejma [mailto:[hidden email]]
> Sent: Tuesday, November 27, 2007 7:57 AM
> To: [hidden email]
> 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 <[hidden email]>:
> >
> > 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
> > [hidden email]
> > [phone]
> >
>
>

[SkipDever]

Hi Krzyzstof

I was just wondering how to pronounce (say) your name "Krzyzstof ".  I have
never seen that name before.

Skip

-----Original Message-----
From: Krzysztof Podejma [mailto:[hidden email]]
Sent: Wednesday, November 28, 2007 8:07 AM
To: [hidden email]
Subject: Re: Postgres dump/restore - our promotions are broken!


???

2007/11/27, skip@thedevers <[hidden email]>:

>
> I would love to know how to pronounce Krzysztof.
>
> Skip
>
> -----Original Message-----
> From: Krzysztof Podejma [mailto:[hidden email]]
> Sent: Tuesday, November 27, 2007 7:57 AM
> To: [hidden email]
> 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 <[hidden email]>:
> >
> > 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
> > [hidden email]
> > [phone]
> >
>
>

[Krzysztof Podejma]

It is Christopher in polish. ;]

2007/11/28, skip@thedevers <[hidden email]>:

>
> Hi Krzyzstof
>
> I was just wondering how to pronounce (say) your name "Krzyzstof ".  I
> have
> never seen that name before.
>
> Skip
>
> -----Original Message-----
> From: Krzysztof Podejma [mailto:[hidden email]]
> Sent: Wednesday, November 28, 2007 8:07 AM
> To: [hidden email]
> Subject: Re: Postgres dump/restore - our promotions are broken!
>
>
> ???
>
> 2007/11/27, skip@thedevers <[hidden email]>:
> >
> > I would love to know how to pronounce Krzysztof.
> >
> > Skip
> >
> > -----Original Message-----
> > From: Krzysztof Podejma [mailto:[hidden email]]
> > Sent: Tuesday, November 27, 2007 7:57 AM
> > To: [hidden email]
> > 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 <[hidden email]>:
> > >
> > > 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
> > > [hidden email]
> > > [phone]
> > >
> >
> >
>
>