Re: version upgrade

Jan Wieck wrote:


> Which is another point I was about to ask. How do these people, running 
> those huge and horribly important databases, ever test a single 
> application change? Or any schema changes for that matter. Do they 
> really type "psql -c 'alter table ...' proddb" and believe they are 
> professional users because they know what they are doing?

I do alter table, but of course before to do it, I run my regression test
on a database with almost no data inside. Each stored procedure is tested
in order to execute each execution path.
In 3 years working in this way I had no a singol failure after an alter
schema operation.


Regards
Gaetano Mendola