Re: [GUSDEV] dropping GUS schemas

[Mark H. <mh...@ug...>]

Hi Konika,

Sorry, we assumed you were using Oracle when we sent the 'drop user'  
instructions. John is right about the syntax for postgres. Also, the  
instruction to drop the ApiDB schema was included by mistake in the  
earlier email. That schema is custom for our project so doesn't apply  
to you.

What version of GUS are you using? The notdefyet error may be the  
result of an old bug that was fixed in 2005. The GUS-3.5.0.0.tar.gz  
file on the download site does not have the fix.

Check the file GUS/ObjRelP/lib/perl/Generator/GeneratorFunctions.pm to  
see if it has this elsif statement around line 48:

    elsif (uc($oraType) eq "TIMESTAMP" ) {
        $newType .= "Timestamp";
    }

I'm attaching a patched version GeneratorFunctions.pm.

Alternatively you can checkout the most recent code from the  
Subversion repository. I have successfully installed the GUS schema in  
Postgres with that code.
See http://www.gusdb.org/download.php .

Mark Heiges
EuPathDB Bioinformatics Resource Center
Center for Tropical and Emerging Global Diseases
Paul D. Coverdell Center, Rm 370
500 D. W. Brooks Drive
University of Georgia, Athens, GA 30602