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

[Dequan (D. K. <dk...@vb...>]

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