Import and triggers

Bart Pietercil bart.pietercil at cognosis.be
Tue Aug 19 09:53:15 CDT 2008


also send this to Valentina List (should have sent it through there to  
begin with)


Hi Ivan,

I don't mean when loading a sql dump but when importing data (tab- 
delim) through the import record command in VStudio


On 19 Aug 2008, at 16:31, Ivan Smahin wrote:

> Hello Ruslan,
>
> Tuesday, August 19, 2008, 5:23:20 PM, you wrote:
>
>> On 8/19/08 5:14 PM, "Bart Pietercil" <bart.pietercil at cognosis.be>  
>> wrote:
>
>>> Hi Ruslan,
>>>
>>> when importing records through VStudio into a table with
>>> on_insert_triggers defined are those triggers triggered ?
>
>> Hi Bart,
>
>> Ivan can you check this ?
>> And add this info right now to WIKI in to sections of triggers.
>
>
>> By idea:
>
>> Triggers are called by our low level Table.AddRecord()
>> Importer also use it.
>> So yes should be fired.
>
>
>> Ivan, we have way to DISABLE triggers on some time, especially for  
>> such
>> ADMIN tasks, right ?
>
>
> Actually triggers are very last things which are created in the dump.
> You can check it.
> So no triggers are available during data import - just absent yet.
>
>
> -- 
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>



More information about the Valentina mailing list