postgres/perl, autocommit and BEGIN; COMMIT;

[Peter L. Peres]

On Mon, 31 May 2004, Fraser Campbell wrote:

> If invalid input ever touches your db layer then your software has a large
> bug.

Isn't consolidation supposed to check the datbase from time to time, and
whenever needed ? What's your input validation accuracy ? 6 nines ? Do you
really test for such compliance ? With 6 nines you have one error
guaranteed per million records, more if you count character errors and
digit errors. There ain't no such thing as 'perfect input validation'
afaik.

Peter
--
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