[GUSDEV] dropping GUS schemas

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

"drop user apidb cascade" is the Oracle syntax. I think the equivalent for
postgres is:

drop schema apidb;

-- John

On Sun, May 1, 2011 at 1:50 PM, chawla <ch...@bi...> wrote:

>  Hi all
> I tried dropping the database and user , with what suggested by Dr Chris.
> I was confused with the names used here such as  APIDB which doesn't looks
> looks like a user and thus I got the errors with these as shown below.
> but the database mygus and user gus_w was dropped successfully.
>
> After this I try to install gus again and got errors related to java. These
> are shown further below. Kindly suggest a possible solution.
>
>
> drop database mygus;
> DROP DATABASE
> postgres=# drop user APIDB cascade;
> ERROR:  syntax error at or near "cascade"
> LINE 1: drop user APIDB cascade;
>
>                         ^
> postgres=#  drop user STUDYVER cascade;
> ERROR:  syntax error at or near "cascade"
> LINE 1: drop user STUDYVER cascade;
>                            ^
> postgres=#  drop user TESS cascade;
> ERROR:  syntax error at or near "cascade"
> LINE 1: drop user TESS cascade;
>                        ^
> postgres=#  drop user TESSVER cascade;
> ERROR:  syntax error at or near "cascade"
> LINE 1: drop user TESSVER cascade;
>                           ^
> postgres=#  DROP ROLE gus_w;
> DROP ROLE
> postgres=#  DROP ROLE gus_r;
> **********************************************
> build GUS install -append -installDBSchema
>
> errors:
>  [javac] symbol  : class notdefyet
>     [javac] location: class org.gusdb.model.SRes.ECPathway_Row
>     [javac]     public void setModificationDate (notdefyet value)
>     [javac]                                      ^
>     [javac]
> /home/chawla/GUS/project_home/GUS/Model/src/java/org/gusdb/model/SRes/ECPathway_Row.java:83:
> cannot find symbol
>     [javac] symbol  : class notdefyet
>     [javac] location: class org.gusdb.model.SRes.ECPathway_Row
>     [javac]     public notdefyet getModificationDate () { return
> (notdefyet)get_Attribute("modification_date"); }
>     [javac]            ^
>     [javac]
> /home/chawla/GUS/project_home/GUS/Model/src/java/org/gusdb/model/DoTS/AnatomyLOE_Row.java:78:
> cannot find symbol
>     [javac] symbol  : class notdefyet
>     [javac] location: class org.gusdb.model.DoTS.AnatomyLOE_Row
>     [javac]     public void setModificationDate (notdefyet value)
>     [javac]                                      ^
>     [javac]
> /home/chawla/GUS/project_home/GUS/Model/src/java/org/gusdb/model/DoTS/AnatomyLOE_Row.java:83:
> cannot find symbol
>     [javac] symbol  : class notdefyet
>     [javac] location: class org.gusdb.model.DoTS.AnatomyLOE_Row
>     [javac]     public notdefyet getModificationDate () { return
> (notdefyet)get_Attribute("modification_date"); }
>     [javac]            ^
>     [javac]
> /home/chawla/GUS/project_home/GUS/Model/src/java/org/gusdb/model/PROT/FeatureSet_Row.java:86:
> cannot find symbol
>     [javac] symbol  : class notdefyet
>     [javac] location: class org.gusdb.model.PROT.FeatureSet_Row
>     [javac]     public void setModificationDate (notdefyet value)
>     [javac]                                      ^
>     [javac]
> /home/chawla/GUS/project_home/GUS/Model/src/java/org/gusdb/model/PROT/FeatureSet_Row.java:91:
> cannot find symbol
>     [javac] symbol  : class notdefyet
>     [javac] location: class org.gusdb.model.PROT.FeatureSet_Row
>     [javac]     public notdefyet getModificationDate () { return
> (notdefyet)get_Attribute("modification_date"); }
>     [javac]            ^
>     [javac] Note: Some input files use unchecked or unsafe operations.
>     [javac] Note: Recompile with -Xlint:unchecked for details.
>     [javac] 100 errors
>
> Thanks
> Konika
>
>
> On 04/28/2011 12:13 AM, gus...@li... wrote:
>
>
>
> ------
>
> Message: 3
> Date: Wed, 27 Apr 2011 11:38:40 -0300
> From: Rodrigo Jardim <jar...@gm...> <jar...@gm...>
> Subject: Re: [GUSDEV] Build failed - couldn't install GUS
> To: Chris Stoeckert <sto...@pc...> <sto...@pc...>
> Cc: gus...@li..., chawla <ch...@bi...> <ch...@bi...>
> Message-ID: <BANLkTi=KeiJwV=d9i...@ma...> <BANLkTi=KeiJwV=d9i...@ma...>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Dear Konika,
>
> I think your problem could be solved with the parameters -Xmx and -Xms in
> java (JRE). But, I don't know where you put this in the scripts of GUS.
> Maybe Dr. Chris know.  I hope I have helped you. (sorry for my english!)
>
> Regards,
> Rodrigo Jardim
>
> 2011/4/27 Chris Stoeckert <sto...@pc...> <sto...@pc...>
>
>
>
>
> ------------------------------------------------------------------------------
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network
> management toolset available today.  Delivers lowest initial
> acquisition cost and overall TCO of any competing solution.
> http://p.sf.net/sfu/whatsupgold-sd
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>
>