Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • Kea Kea
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 561
    • Issues 561
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 66
    • Merge requests 66
  • Deployments
    • Deployments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • ISC Open Source ProjectsISC Open Source Projects
  • KeaKea
  • Issues
  • #1643
Closed
Open
Issue created Jan 12, 2021 by Sander Steffann@steffann

Missing foreign key for lease6.hwaddr_source

Describe the bug

When inspecting the database structure I noticed (using PostgreSQL) that lease6.hwaddr_source is not a foreign key to lease_hwaddr_source.hwaddr_source. This seems inconsistent as both lease6.state and lease6.lease_type are foreign keys.

To Reproduce

Steps to reproduce the behavior:

  1. Run kea-admin db-init pgsql
  2. Connect to the kea database using psql
  3. Check the database schema with \d lease6

Expected behavior

I would expect lease6.hwaddr_source to be a foreign key as it references values in another table.

Environment:

  • Kea version: isc-kea-admin, deb package 1.9.3-isc001302020121418142
  • OS: Debian GNU/Linux 10 (buster)

Additional Information

None

Contacting you

sander@steffann.nl or +31-6-22660412

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking