starred/netbox
1
0
Fork 0
mirror of https://github.com/netbox-community/netbox.git synced 2026-01-11 21:10:29 +01:00
Code Issues 273 Packages Projects Releases 10 Wiki Activity

Wrong minimum PostgreSQL Version? #3724

New Issue
Closed
opened 2025-12-29 18:30:47 +01:00 by adam · 1 comment
adam commented 2025-12-29 18:30:47 +01:00
Owner
Copy Link

Originally created by @rmuehl on GitHub (May 25, 2020).

Environment

  • Python version: 3.6
  • NetBox version: 2.8.3
  • OS: RHEL7
  • PostgreSQL 9.4.24

Steps to Reproduce

Install Docs says minimum version of postgresql is 9.4.
But when I try to add Users or Groups to a secret role, I get a server error (see below).

It seams, that "ON CONFLICT" is introduced in postgres 9.5.

server error:

<class 'django.db.utils.ProgrammingError'>
syntax error at or near "ON"
LINE 1: ...ups" ("secretrole_id", "group_id") VALUES (12, 1) ON CONFLIC...

pg_log:

ERROR: syntax error at or near "ON" at character 85
STATEMENT: INSERT INTO "secrets_secretrole_users" ("secretrole_id", "user_id") VALUES (11, 18) ON CONFLICT DO NOTHING

Originally created by @rmuehl on GitHub (May 25, 2020). ### Environment * Python version: 3.6 * NetBox version: 2.8.3 * OS: RHEL7 * PostgreSQL 9.4.24 ### Steps to Reproduce Install Docs says minimum version of postgresql is 9.4. But when I try to add Users or Groups to a secret role, I get a server error (see below). It seams, that "ON CONFLICT" is introduced in postgres 9.5. <!-- What happened instead? --> server error: > <class 'django.db.utils.ProgrammingError'> syntax error at or near "ON" LINE 1: ...ups" ("secretrole_id", "group_id") VALUES (12, 1) ON CONFLIC... pg_log: >ERROR: syntax error at or near "ON" at character 85 STATEMENT: INSERT INTO "secrets_secretrole_users" ("secretrole_id", "user_id") VALUES (11, 18) ON CONFLICT DO NOTHING
adam closed this issue 2025-12-29 18:30:47 +01:00
adam commented 2025-12-29 18:30:48 +01:00
Author
Owner
Copy Link

@DanSheps commented on GitHub (May 25, 2020):

Duplicate of #4645

@DanSheps commented on GitHub (May 25, 2020): Duplicate of #4645
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
beta
breaking change
complexity: high
complexity: low
complexity: medium
needs milestone
netbox
pending closure
plugin candidate
pull-request
Mirrored from GitHub Pull Request
 severity: high
severity: low
severity: medium
status: accepted
status: backlog
status: blocked
status: duplicate
status: needs owner
status: needs triage
status: revisions needed
status: under review
topic: GraphQL
topic: Internationalization
topic: OpenAPI
topic: UI/UX
topic: cabling
topic: event rules
topic: htmx navigation
topic: industrialization
topic: migrations
topic: plugins
topic: scripts
topic: templating
topic: testing
type: bug
type: deprecation
type: documentation
type: feature
type: housekeeping
type: translation
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
adam
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#3724
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?