[OPEN-ILS-DEV] Deleting the example branches

[Robert Nix]

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/20080324/8af8be9b/attachment.html