Sending errors from psql to error file

[Devin Whalen]

On Thu, 2004-08-12 at 22:24, cbbrowne-HInyCGIudOg at public.gmane.org wrote:
> > I don't understand what is wrong with my method??
> 
> There's nothing dramatically wrong; it's that if you can characterize
> the process of transforming the old data into the new form in a
> well-defined "phased" fashion, you can readily audit the way the changes
> worked, and be _very_ sure of what happened, because you can document
> the steps.
> 
> This may not be so important with a web "message board" application
> where nobody much cares if a few old items get trashed.
> 
> It appears that several of our national banks have gotten bitten badly
> of late by software changes that wound up trashing data on them; their
> ability to recover has depended on having well-defined transitions...
> 
> There's certainly "more than one way to skin the cat;" the methodology
> I'm suggesting happens to be one I and my colleagues have found useful.
> I have done quite a lot of data conversions over the years, and this is
> the slickest approach I have seen...


Thanks for the input.  You just scared me there when you referred to my
method as 'questionable'.  I think I will stick to my method though,
since I feel it is the best way (even though it may be slow) but mostly
since I am comfortable with it.


Later




-- 
Devin Whalen
Programmer
Synaptic Vision Inc
Phone-(416) 539-0801
Fax- (416) 539-8280
1179A King St. West
Toronto, Ontario
Suite 309 M6K 3C5
Home-(416) 653-3982
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml