[db-wg] Proposal to accept same INET(6)NUM objects with different status

Dear DB-WG Members

Proposal:

I propose to allow two INET(6)NUM objects with the same value of
inet(6)num attribute and different status to be put into the DB.

Problem description:

According to current DB/business rules it is impossible to put into the
database two INET(6)NUM objects with the same value of inet(6)num
attribute and different status.

This situation is quite problematic when an LIR which receive /22 from
the last /8 cannot put this exact /22 with "ASSIGNED PA" status into the
DB (this will result with en error). The current practice is way from
being ideal - one have to divide this /22 to at least two smaller
assignments.

This problem is more relevant but not limited to the new LIRs which
receive their initial and only allocation and assign it as one single
block to themselves.

Some possible problems to be addressed:

1. Should this be limited to certain top/bottom status pairs (like
ALLOCATED PA->ASSIGNED PA).

IMHO yes.

2. Shoud DB return both INET(6)NUM object matching the query?

I'm open to both options (special query flag could be introduced if
necessary).

3. How to delete/modify correct INET(6)NUM object.

While deleting, exact copy must match. While modifying, status line
select the one to be modified.

Looking for your comments.

Piotr

-- 
gucio -> Piotr Strzyżewski
E-mail: Piotr.Strzyzewski at polsl.pl