org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fk9dc3e34d34a4917e" on table "attachmentdata" Detail: Key (attachmentid)=(1778090269) is still referenced from table "attachmentdata".

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via Atlassian JIRA by Per Fragemann [Atlassian], 1 year ago
ERROR: update or delete on table "attachments" violates foreign key constraint "fk9dc3e34d34a4917e" on table "attachmentdata" Detail: Key (attachmentid)=(1778090269) is still referenced from table "attachmentdata".
via Atlassian JIRA by Per Fragemann [Atlassian], 1 year ago
ERROR: update or delete on table "attachments" violates foreign key constraint "fk9dc3e34d34a4917e" on table "attachmentdata" Detail: Key (attachmentid)=(1778090269) is still referenced from table "attachmentdata".
via Atlassian JIRA by Andrew Lui [Atlassian technical writer], 1 year ago
ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(225247903) is still referenced from table "imagedetails".
via Atlassian JIRA by Andrew Lui [Atlassian technical writer], 1 year ago
ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".
via Atlassian JIRA by Andrew Lui [Atlassian technical writer], 1 year ago
ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(225247903) is still referenced from table "imagedetails".
via atlassian.com by Unknown author, 2 years ago
ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(209027171) is still referenced from table "imagedetails".
org.postgresql.util.PSQLException: ERROR: update or delete on table "attachments" violates foreign key constraint "fk9dc3e34d34a4917e" on table "attachmentdata" Detail: Key (attachmentid)=(1778090269) is still referenced from table "attachmentdata".

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 9 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 3 days ago
Once, 6 days ago
Samebug visitor profile picture
Unknown user
Once, 6 days ago
99 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.