[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