PostgreSQL Database - Error Assistance

Question

I'm trying to create a query that will update the value of rgn_no and chp_cd within the table bue to the values of rgn_no and chp_cd within the table chapterassociation. I don't think the WHERE clause is any problems, but I'm getting the following error when I run it in:

SQL error:

ERROR:  insert or update on table "bue" violates foreign key constraint "bue_chp_cd_fkey"
DETAIL:  Key (chp_cd)=(CA3) is not present in table "chapter".

Any assistance is greatly appreciated!

SQL Query:

UPDATE bue SET
 rgn_no = chapterassociation.rgn_no,
 chp_cd = chapterassociation.chp_cd
FROM
 chapterassociation
WHERE
 bue.mbr_no IS NULL AND bue.chp_cd IS NULL
 AND bue.work_state = chapterassociation.work_state
 AND bue.bgu_cd = chapterassociation.bgu_cd

wildplasser · Accepted Answer · 2012-04-30 17:27:50Z

3

Read the error message:

ERROR: insert or update on table "bue" violates foreign key constraint
"bue_chp_cd_fkey" DETAIL: Key (chp_cd)=(CA3) is not present in table "chapter".

It says that one of your updates wants to set chp_cd to 'CA3', but that CA3 is not an allowed value, because a foreign key constraint wants the value 'CA3" to be present in the table "chapter". That's all.

There is nothing wrong with your query's syntax, it is just the fact that your query would cause the data to conflict with a constraint in the data model.

edited Apr 30, 2012 at 17:27

answered Apr 30, 2012 at 16:40

wildplasser

44.5k9 gold badges72 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL Database - Error Assistance

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related