smallint is too small for dcim_powerfeed.available_power #3080

Closed
opened 2025-12-29 18:25:26 +01:00 by adam · 1 comment
Owner

Originally created by @zenches on GitHub (Dec 20, 2019).

Environment

  • Python version: 3.7.3
  • NetBox version: v2.6.9

Proposed Functionality

Change datatype for column available_power to integer.

Use Case

smallint for available_power is not enough, when i creating new power feed with parameters:

  • Voltage: 380
  • Amperage: 63
  • Phase: Three-phase

These options corresponds to my UPS manual and implemented on my datacenter.
Changing data type to integer helps me.

Database Changes

netbox=# ALTER TABLE dcim_powerfeed ALTER COLUMN available_power SET DATA TYPE integer;

External Dependencies

Probably, no dependencies.

Originally created by @zenches on GitHub (Dec 20, 2019). <!-- NOTE: This form is only for proposing specific new features or enhancements. If you have a general idea or question, please post to our mailing list instead of opening an issue: https://groups.google.com/forum/#!forum/netbox-discuss NOTE: Due to an excessive backlog of feature requests, we are not currently accepting any proposals which significantly extend NetBox's feature scope. Please describe the environment in which you are running NetBox. Be sure that you are running an unmodified instance of the latest stable release before submitting a bug report. --> ### Environment * Python version: 3.7.3 * NetBox version: v2.6.9 <!-- Describe in detail the new functionality you are proposing. Include any specific changes to work flows, data models, or the user interface. --> ### Proposed Functionality Change datatype for column available_power to integer. <!-- Convey an example use case for your proposed feature. Write from the perspective of a NetBox user who would benefit from the proposed functionality and describe how. ---> ### Use Case smallint for available_power is not enough, when i creating new power feed with parameters: - Voltage: 380 - Amperage: 63 - Phase: Three-phase These options corresponds to my UPS manual and implemented on my datacenter. Changing data type to integer helps me. <!-- Note any changes to the database schema necessary to support the new feature. For example, does the proposal require adding a new model or field? (Not all new features require database changes.) ---> ### Database Changes `netbox=# ALTER TABLE dcim_powerfeed ALTER COLUMN available_power SET DATA TYPE integer;` <!-- List any new dependencies on external libraries or services that this new feature would introduce. For example, does the proposal require the installation of a new Python package? (Not all new features introduce new dependencies.) --> ### External Dependencies Probably, no dependencies.
adam added the status: duplicate label 2025-12-29 18:25:26 +01:00
adam closed this issue 2025-12-29 18:25:26 +01:00
Author
Owner

@DanSheps commented on GitHub (Dec 20, 2019):

Thank you for submitting this issue, however it appears that this topic has already been raised. Please see issue #3706 for further discussion.

@DanSheps commented on GitHub (Dec 20, 2019): Thank you for submitting this issue, however it appears that this topic has already been raised. Please see issue #3706 for further discussion.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#3080