org.postgresql.util.PSQLException

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".

Samebug tips1

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>

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web3203

  • via Atlassian JIRA by Andrew Lui [Atlassian technical writer], 11 months 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)=(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".
  • Stack trace

    • org.postgresql.util.PSQLException: 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". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 5 months ago
    Unknown user
    Once, 1 year ago
    Once, 3 weeks ago
    26 times, 1 month ago
    7 times, 1 month ago
    89 more bugmates