Re: [GUSDEV] bug in GUS schema, evidentiated by InsertSequenceFeatures

[John I. <io...@pc...>]

Antonio,

I am building a GUS database using PostgreSQL, so I will likely  
encounter the same problem.  If so, I'll have to find a fix or  
workaround in the next few weeks.

Can you tell me more about what was happening when the error occurred?

Mike mentioned the install logs; do you still have those?  If so,  
please send me a copy.

There are some other people using GUS and PostgreSQL.  Do you know  
why they haven't encountered the error (or how they worked around it)?

Even if it isn't a problem for my project, I'll help if I can; part  
of my job is to contribute to the development of PostgreSQL GUS, so  
I'd like to see this fixed.  Email me (or the group) with any  
progress you make, and I'll do the same.

John Iodice

On Oct 16, 2006, at 3:12 PM, gusdev-gusdev- 
re...@li... wrote:
> Hello,
> did anyone have the time to look into the issue I submitted and  
> confirm it?
>
> Thank you very much,
>
> Antonio
>
> Quoting an...@ne...:
>
>> Quoting Michael Saffitz <m...@sa...>:
>>
>>> Antonio is correct here-- it looks like the postgres triggers  
>>> aren't being
>>> correctly generated for this table. I had thought I had fixed  
>>> this, but I
>>> guess not.  These are in the db writer for postgres within the db  
>>> admin
>>> package.  Search for 'ON INSERT TO'.  Antonio-- it may help if  
>>> you forward
>>> along your install logs (that include all SQL used in generating the
>>> instance).
>>> Steve's also correct-- bug 177 appears to track a different issue.
>>
>> I fear that while the database error does appear to be different, the
>> underlying issue is exactly the same.
>>
>> Following Steve's advice to try suggesting a fix, I've been  
>> digging further.
>> If I got your code correctly, all this wreck is generated when the  
>> schema
>> hierarchy gets converted, in
>>
>>  GUS/DBAdmin/src/java/org/gusdb/dbadmin/util/ 
>> GusClassHierarchyConverter.java
>>
>> In function 'buildSuperClassView', (around line 440 in GUS 3.5; but
>> 'buildSubClassView' exhibits the same issue) the code goes like this:
>>
>> --------------------------------------------------------------------- 
>> -------
>> // Housekeeping Columns and complete for the Version View
>> if (impTable.isVersioned()) {
>>   superClassView.setVersioned(true);
>>   verSql = sql.concat(" ");
>>
>>   for (Iterator i = verHousekeepingColumns.iterator(); i.hasNext 
>> ();) {
>>     Column column = (Column)i.next();
>>     verSql = verSql.concat(", " + column.getName());
>>     superClassView.getVersionView().addColumn(new
>> ColumnPair(column.getName(),
>>              column.getName()));
>>   }
>>   verSql = verSql.concat(
>>     " FROM " +
>>     impTable.getVersionTable().getSchema().getName() +
>>     "." + impTable.getVersionTable().getName() +
>>     ";");
>>   superClassView.getVersionView().setSql(verSql);
>> }
>> --------------------------------------------------------------------- 
>> -------
>>
>> Now, the problem is that while 'verSql' is correctly generated  
>> (because it
>> starts with 'sql'), the original view's colums are not copied at all.
>>
>> The reason is that GusView behaves differently from GusTable,  
>> since its
>> 'setVersioned()' method does not copy the base view colums as one  
>> might have
>> expected after having looked at GusTable.
>>
>> As far as I can tell this has no relation to the actual database  
>> instance in
>> use, but I'd say that this is the core of the problem.
>>
>> HTH,
>>
>> Antonio
>>
>>
>> ----------------------------------------------------------------
>> Net Wise webmail system - http://www.netwise.it
>> This message was sent using IMP, the Internet Messaging Program.
>>
>>
>> --------------------------------------------------------------------- 
>> ----
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to  
>> share your
>> opinions on IT & business topics through brief surveys -- and earn  
>> cash
>> http://www.techsay.com/default.php? 
>> page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Gusdev-gusdev mailing list
>> Gus...@li...
>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>
>> !DSPAM:452a0cfd138065873587180!
>>
>>
>
>
>
>
> ----------------------------------------------------------------
> Net Wise webmail system - http://www.netwise.it
> This message was sent using IMP, the Internet Messaging Program.