Errors in manage.sql

[Morten Brekkevold]

Running doc/sql/manage.sql gives the following errors:
---
psql:doc/sql/manage.sql:216: ERROR: relation "arp" does not exist
psql:doc/sql/manage.sql:220: ERROR: relation "cam" does not exist
psql:doc/sql/manage.sql:819: ERROR: operator does not exist: character
varying = integer
---

The rules netbox_close_arp and netbox_close_cam are defined on the netbox
table, referring to the cam and arp tables before they are created.

Also, the definition of the rule rrdfile_deleter will fail on PostgreSQL
8.3 because of its stricter typecasting rules.

[http://sourceforge.net/tracker/index.php?func=detail&aid=2023345&group_id=107608&atid=648170]

[Morten Brekkevold (mbrekkevold)]

Originator: YES

Fixed in changeset fe8433bc7f39, pushed to series/3.4.x and default. Looks
like we'll have to push a 3.4.2 version soon.

[Morten Brekkevold (mbrekkevold)]

Originator: YES

Just an update about the ramifications of these bugs:

The netbox_close_arp and netbox_close_cam will cause errors in machine
tracking history as netboxes are deleted, and are potentially serious.

The rrdfile_deleter problem is relatively minor; it deletes NAV's
knowledge of an RRD file related to a service when the service checker is
deleted. Other parts of NAV will fix this when it sees the RRD file hasn't
been updated for 30 days.