Re: [Gusdev-gusdev] How are the dotsver etc. schemas are used

[Deborah P. <pi...@pc...>]

Hi Derek,
No you don't want to version the version tables so you don't want to set 
their is_versioned attribute to 1, just the non-version tables. As I 
said, when using the objects to insert, update or delete, there is 
automatic versioning in your case (is_versioned =1 for all the tables). 
With a script that uses DBI, the script must explicity insert into the 
version tables before deleting. If you are deleting using something like 
sqlplus, there will not be any versioning unless you do it, again 
explicity, prior to deleting from teh non-version table. I don't know 
how you deleted but if you did it with dbvis or sqlplus, there would be 
no entries into the version tables. So, you can't conclude that 
versioning is not working.

                                                                                                                                    
-Debbie


Dequan (Derek) Kong wrote:

> Hi Deborah:
>
> Thanks!
>
> I checked my database.  I found that the  is_version of core.tableinfo 
> is all set to 1 in the standard schema tables, but they are set to 0 
> in all the tables of the version  schema.  Do I have to change all of 
> them to 1.  Would you please explain a little bit more about how the 
> version system in GUS works?  I have deleted many rows from my GUS 
> database, but I did not find any row inserted into the table of 
> version schema.  Is this means that my version system does not work or 
> I need to configure other stuff to make it work!
>
> By the way, how and when did those 1 or 0 in the core.tableinfo are set?
>
> Thanks again for your help!
>
> Derek
>
>
>
>
> At 01:16 PM 12/9/2004 -0500, Deborah Pinney wrote:
>
>> Hi Derek,
>> I'm sorry to disappoint you but I have not written such a script and 
>> don't know of one. The table objects can automatically version and 
>> will if core.TableInfo.is_versioned is set to 1 (not nullable).  When 
>> versioning is on, rows are put into the corresponding 
>> spacever.tablever when rows are being deleted or updated. The primary 
>> key of the version tables is a combination of PK and modification 
>> date (from the original row). Apart from the objects, there are 
>> scripts for specific purposes that put rows in the corresponding 
>> version table prior to  deleting them. These scripts  generally  do 
>> this using DBI do statements.
>>
>> Does anyone else know about a plugin or script dealing with versioning?
>>
>>                                                                     
>> -Debbie
>>
>>
>>
>> Dequan (Derek) Kong wrote:
>>
>>> To Debbie Pinney
>>>
>>> Hi Debbie:
>>>
>>> Sucheta told me that you have written a plugin or program in CBIL to 
>>> control the data Version using  the ver schemas in GUS.  Can I get 
>>> the plugin or program if you have one?
>>>
>>> Thanks!
>>>
>>> Derek
>>>
>>>
>>>
>>>
>>>
>>> At 10:19 AM 12/9/2004 -0500, Sucheta Tripathy wrote:
>>>
>>>> Hi Derek,
>>>>
>>>> The ver schema is used for storing any deleted objects from the 
>>>> main database.
>>>>
>>>>  The deleteentry.pl script does not take care of it. Either the user
>>>> has to do it himself or get it from CBIL (they have a script, which 
>>>> does that.)
>>>>
>>>> cheers
>>>>
>>>> Sucheta
>>>>
>>>>
>>>>
>>>>
>>>> At 08:14 AM 12/9/2004 -0500, Dequan (Derek) Kong wrote:
>>>>
>>>>>> Hi:
>>>>>
>>>>>
>>>>>
>>>>> Can anyone tell me how the vers schemas are used in the version 
>>>>> control of the GUS?
>>>>>
>>>>> Thanks!
>>>>>
>>>>> Derek
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> -------------------------------------------------------
>>>>> SF email is sponsored by - The IT Product Guide
>>>>> Read honest & candid reviews on hundreds of IT Products from real 
>>>>> users.
>>>>> Discover which products truly live up to the hype. Start reading 
>>>>> now. http://productguide.itmanagersjournal.com/
>>>>> _______________________________________________
>>>>> Gusdev-gusdev mailing list
>>>>> Gus...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>>
>>>
>>>
>>>
>>>
>>> -------------------------------------------------------
>>> SF email is sponsored by - The IT Product Guide
>>> Read honest & candid reviews on hundreds of IT Products from real 
>>> users.
>>> Discover which products truly live up to the hype. Start reading 
>>> now. http://productguide.itmanagersjournal.com/
>>> _______________________________________________
>>> Gusdev-gusdev mailing list
>>> Gus...@li...
>>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>
>