Re: HELP: Urgent, Vacuum problem - Mailing list pgsql-general

From Scott Marlowe
Subject Re: HELP: Urgent, Vacuum problem
Date
Msg-id 1165423265.14565.469.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: HELP: Urgent, Vacuum problem  (Vivek Khera <vivek@khera.org>)
List pgsql-general
On Wed, 2006-12-06 at 10:15, Vivek Khera wrote:
> On Dec 5, 2006, at 4:09 PM, Scott Marlowe wrote:
>
> > I recently tossed 8.1 on my workstation which runs a little reporting
> > application here.  I pointed the app from 7.4 to 8.1 and got a visit
> > within about an hour from a user, asking if I'd done anything to my
> > database.  Worrying that I'd made some mistake and he was getting an
>
> I think you got lucky.  We had some issues with the transition from
> 7.4 to 8.0 due to more strictness of some queries, and some changes
> in how strings were interpreted as numbers.  They were minor issues,
> but you really need to regression test your app against new major
> releases of Pg.

Well, actually I knew about those kinds of things and had already made
changes in any queries that would need it.  Basically, I wrote the
reporting app, and I wrote the queries, and after the change, there were
only like 2 queries that needed any changing that I hadn't caught.

Just because I didn't mention any testing doesn't mean none got done...
:)

pgsql-general by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: Why does explain differ from explan analyze?
Next
From: Devrim GUNDUZ
Date:
Subject: Re: Error in installing compat-postgresql-libs rpm