Opened 4 years ago

Last modified 4 years ago

#4078 new enhancement

Use PostgreSQL data types for leases

Reported by: shane Owned by:
Priority: medium Milestone: Outstanding Tasks
Component: Unclassified Version: git
Keywords: Cc:
CVSS Scoring: Parent Tickets:
Sensitive: no Defect Severity: N/A
Sub-Project: DHCP Feature Depending on Ticket:
Estimated Difficulty: 0 Add Hours to Ticket: 0
Total Hours: 0 Internal?: no


The current PostgreSQL schema uses a bigint for the address in IPv4, a varchar(39) for the address in IPv6, and a bytea for the MAC address.

PostgreSQL has native types for these: inet covers both IPv4 and IPv6 addresses, and the macaddr type for hardware addresses.

It is nicer for an administrator to avoid having to do type coercion (and prevents cases where improperly-done coercion means that indexes are not used).


Change History (2)

comment:1 Changed 4 years ago by hschempf

  • Milestone changed from Kea-proposed to DHCP Outstanding Tasks

Per team meeting Oct 14, move to outstanding (we aren't accepting new tickets in 1.0 unless they are urgent or related to client class)

comment:2 Changed 4 years ago by tomek

  • Milestone changed from DHCP Outstanding Tasks to Outstanding Tasks

Milestone renamed

Note: See TracTickets for help on using tickets.