[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 Tue, Mar 25, 2008 at 9:50 AM, Robert Nix <glibrarysystem at gmail.com>
wrote:

> 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/20080331/64ee7e1c/attachment.html