[Babase] Dupe Cenids in DEMOG

Karl O. Pinc babase@www.eco.princeton.edu
Thu, 25 Aug 2005 16:06:46 +0000


On 08/25/2005 10:50:54 AM, Catherine Markham wrote:
>> The rules are checked at the moment the database sees data input
>> or changed, for the most part.  It checks all the rules associated
>> with the data being input or changed.  There's a few conditions
>> that need to run on a schedule but only because it's impossible
>> to tell (automatically) when an full set of changes has been made.
>> 
>> So, you should see errors as soon as you make them.
> 
> Ok, but there is still a difference between that process and the  
> validation programs, right?  I think what I'm trying to get at is  
> that this sounds great, but I'm assuming that this new checking isn't  
> going to replace the various validation programs (in other words,  
> we're going to have both checks - the validation programs aren't  
> going to be obsolete with the new system).

Nope, there are no validation programs.  All the validation is built-in
and automatic.  Doing this is where a lot of my time has been going
as I've wanted it done before converting.

The update programs will use transactions, which you can use too.
http://www.postgresql.org/docs/7.4/static/tutorial-transactions.html
With transactions if you get one error then none of the changes
get made.  Then you fix the error and try all the changes again
in another transaction.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein