Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Postgres 'duplicate key value'

Hi,

I've recently (almost) completed my migration from MySQL to built in Postgres.

I'll write it up properly when finished.

WHD is now using the built in Postgres database, but I'm having problems with a couple of fields/ tables

ATTACHMENT_DATA(ID, FILE_DATA)

tech_note_id

Some new tickets have been rejected and I can't add notes into tickets because of the error 'duplicate key value'

Support have sent me a couple of links to try, but I'm sure I'll find more of these- is there a way to fix them all at once?

Here are the links supplied-

https://hcmc.uvic.ca/blogs/index.php?blog=22&p=8105&more=1&c=1&tb=1&pb=1

https://dba.stackexchange.com/questions/193568/how-to-fix-all-duplicate-key-value-violates-unique-constraint

Or is there some sort of inbuilt database health check?

Find more posts tagged with

Accepted answers

All comments

There are no accepted answers yet

Quick Links