Grouper Developers Forum

[Chris Hyzer <>]

I tried this and it worked, but tried to add constraints that were already 
there [another issue].  I can fix that.  Attached is the script mine 
generated (and scrubbed) to add views.  If you run that against your DB, you 
will have the views again.

Regarding the IDs, I have an idea.  I think you might have multiple schemas 
in one DB (or multiple something there) which have the same table name.  Im 
not saying that is a bad thing, and it should be supported by apache 
ddlutils, but maybe that is the problem.  Attached in gif is my postgres 
structure.  I have one DB, with a schema named "public", and one user which 
connects to it.  What is your structure?  Can you send me a screenshot like 
this with pgAdmin?  Note, I am running pgadmin on windows, and tunneling 
traffic through SSH to my postgres linux box.  If this isn’t the problem, 
maybe I can give you a small jdbc metadata program which can figure out the 
problem if I have the stack that you emailed before.

Regards,
Chris

Ps. Here is the bug about adding constraints not there:

https://bugs.internet2.edu/jira/browse/GRP-237



> -----Original Message-----
> From: Dr. Loris Bennett 
> [mailto:]
> Sent: Friday, February 27, 2009 9:57 AM
> To: Chris Hyzer
> Cc: Grouper Dev Mailing List
> Subject: RE: [grouper-dev] Creation of "common views" when DB is
> initialised?
> 
> On Fri, 2009-02-27 at 09:37 -0500, Chris Hyzer wrote:
> > When it says its up to date, it is just looking at what version is in
> the grouper_ddl table, it isn’t actually checking the structure.
> >
> > If you do a:
> >
> > gsh.sh -registry -deep
> 
> This gives me the error
> 
>         Grouper ddl object type 'Grouper' has dbVersion: 0 and java
>         version: 13
>         org.apache.ddlutils.model.ModelException: There are multiple
>         column with the name id in the table grouper_attributes
> 
> Didn't we have something like that before, due to some issue with
> postgres?
> 
> > or:
> >
> > gsh.sh -registry -deep -runscript
> >
> > That will generate and/or run the script that will check all the
> tables and cols and views and stuff.  It should recreate all your
> views, though it is a probably a good idea in non-dev to run the first
> one, and look at the script that will run (and potentially edit it if
> there are problems).  :)  Let me know if there are issues.
> >
> > Regards,
> > Chris
> >
> > > -----Original Message-----
> > > From: Dr. Loris Bennett 
> > > [mailto:]
> > > Sent: Friday, February 27, 2009 9:28 AM
> > > To: Chris Hyzer
> > > Cc: Grouper Dev Mailing List
> > > Subject: RE: [grouper-dev] Creation of "common views" when DB is
> > > initialised?
> > >
> > > On Fri, 2009-02-27 at 08:46 -0500, Chris Hyzer wrote:
> > > > 1. Have you looked at grouper_groups_v?  It might be too
> heavyweight
> > > for what you need
> > >
> > > Now, you mention it, I did have a look at that before. However, my
> > > current DB doesn't contain any views at all. Backups of the DB for
> > > previous Grouper version do, I now notice.
> > >
> > >         bin/gsh.sh -registry -check
> > >
> > > on the current, view-less DB says
> > >
> > >         database table/object structure (ddl) is up to date
> > >
> > > Did something not get initialised or did I just misclick somewhere
> and
> > > delete all the views?
> > >
> > > Cheers
> > >
> > > Loris
> > >
> > > > 2. In grouper 1.5, those cols are moving to the grouper_groups
> table,
> > > so the view might not be necessary
> > > >
> > > > But yes, we can add this or other views to core grouper if people
> > > find them useful...  I already would like to see a better
> lightweight
> > > membership view:
> > > >
> > > > https://bugs.internet2.edu/jira/browse/GRP-231
> > > >
> > > > Chris
> > > >
> > > > > -----Original Message-----
> > > > > From: Dr. Loris Bennett 
> > > > > [mailto:]
> > > > > Sent: Friday, February 27, 2009 7:20 AM
> > > > > To: Grouper Dev Mailing List
> > > > > Subject: [grouper-dev] Creation of "common views" when DB is
> > > > > initialised?
> > > > >
> > > > > Hi,
> > > > >
> > > > > I am just trying out some stuff with grouperloader and,
> following
> > > one
> > > > > of
> > > > > Chris' examples, using a view which provides me with id, name,
> > > > > displayName, description for groups. Such a view seems to me to
> be
> > > so
> > > > > useful that I feel it would be nice if it were created when the
> > > grouper
> > > > > DB is initialised.
> > > > >
> > > > > I am sure there may well be other canditates for "common
> views".
> > > > >
> > > > > Thoughts?
> > > > >
> > > > > Loris
> > > > >
> > > > > --
> > > > > Dr. Loris Bennett (Mr.)
> > > > > Freie Universität Berlin
> > > > > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer
> Center
> > > > > Compute & Media Service
> > > > > Fabeckstr. 32, Room 221
> > > > > D-14195 Berlin
> > > > > Tel ++49 30 838 51024
> > > > > Fax ++49 30 838 56721
> > > > > Email 
> > > > > 
> > > > > Web www.zedat.fu-berlin.de
> > > >
> > > --
> > > Dr. Loris Bennett (Mr.)
> > > Freie Universität Berlin
> > > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
> > > Compute & Media Service
> > > Fabeckstr. 32, Room 221
> > > D-14195 Berlin
> > > Tel ++49 30 838 51024
> > > Fax ++49 30 838 56721
> > > Email 
> > > 
> > > Web www.zedat.fu-berlin.de
> >
> --
> Dr. Loris Bennett (Mr.)
> Freie Universität Berlin
> ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
> Compute & Media Service
> Fabeckstr. 32, Room 221
> D-14195 Berlin
> Tel ++49 30 838 51024
> Fax ++49 30 838 56721
> Email 
> 
> Web www.zedat.fu-berlin.de

Attachment: grouperDdl_20090227_10_04_04_798.sql
Description: grouperDdl_20090227_10_04_04_798.sql

Attachment: postgres.gif
Description: postgres.gif