[OPEN-ILS-DEV] Deleting the example branches

[Robert Nix]

Mike,

  I keep getting the foreign key restraints error and I can't figure out
which tables are linked to go deeper to delete the items from it. I have
found that the items are linked to the tables actor.org_unit_type and
transit_copy. In the actor.org_unit_type I can't delete the relations there
either because of the same error and I can't even get the transit_copy table
to display any information to see what relations are there. I keep getting
the error: relation "transit_copy" does not exist. I know it's there because
of the error I get when trying to delete the parent_ou for the example
libraries. It says DETAIL: Key (id)=(12) is still referenced from table
"transit_copy". Any suggestions or table names I can start from would be
greatly appreciated. I have very little DB knowledge as I have not worked
with them very long. I have only worked with very rudementary things in DB's
such as importing sql files and basic queries.

Thanks again in advance,
Robert

On Mon, Mar 24, 2008 at 9:50 AM, Robert Nix <glibrarysystem at gmail.com>
wrote:

> Mike,
>
>   Thanks for the suggestion but I'm not familiar enough with sql commands
> to dig to the deeper trees to find where these items are linked to delete
> them. Any suggestions are appreciated. In the mean time I'll be looking in
> some postgres material online to figure out how to get to those deeper
> elements to delete them. Also, I used the install script from John Schmidt
> so the database was created for me which is another reason that I'm not sure
> of the order of tables or the names of those tables in which I need to
> delete the items from first.
>
> Thanks in advance for all of the help,
> Robert
>
>   On Fri, Mar 21, 2008 at 6:20 PM, Mike Rylander <mrylander at gmail.com>
> wrote:
>
> > On Fri, Mar 21, 2008 at 4:14 PM, Robert Nix <glibrarysystem at gmail.com>
> > wrote:
> > > Dan,
> > >
> > >   I tried to delete them from postgres but I get the error that it
> > violates
> > > the foreign key constraint "org_unit_parent_ou_fkey" on "org_unit" and
> > the
> > > detail on that is that the Key is sitll referenced from table
> > "org_unit".
> > > Any thoughts on this error? I understand the concept of the foreign
> > key as
> > > it is a primary key in another table but I don't know how to get
> > around this
> > > error. I would assume it needs to be deleted in the org_unit first
> > before
> > > deleting it from the actor.org_unit table. Is this a correct
> > assumption?
> > >
> >
> > You'll just need to remove the subordinate org units first.  Delete
> > from the deepest part of the tree out.  This constraint is in there to
> > avoid accidental deletion of an object that's in use.
> >
> > Let us know if that does/doesn't help!
> >
> > --
> > Mike Rylander
> >  | VP, Research and Design
> >  | Equinox Software, Inc. / The Evergreen Experts
> >  | phone: 1-877-OPEN-ILS (673-6457)
> >  | email: miker at esilibrary.com
> >  | web: http://www.esilibrary.com
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20080325/27b3b4f6/attachment.html