After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 318440 - Planner crashes whent exporting a project in database.
Planner crashes whent exporting a project in database.
Status: RESOLVED NOTGNOME
Product: planner
Classification: Other
Component: General
unspecified
Other Linux
: Normal normal
: ---
Assigned To: planner-maint
planner-maint
Depends on:
Blocks:
 
 
Reported: 2005-10-10 10:59 UTC by Masoud Reyhanei Hamedanei
Modified: 2008-01-19 21:44 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Masoud Reyhanei Hamedanei 2005-10-10 10:59:50 UTC 
When I import a project from database, and change it, I can not export it to DB
again. This error message appears: 

 
ERROR:  insert or update on table "calendar" violates foreign key constraint
"project_proj_id"
DETAIL:  Key (proj_id)=(3) is not present in table "project".
CONTEXT:  SQL statement "UPDATE ONLY "public"."calendar" SET "day_sun" = DEFAULT
WHERE "day_sun" = $1"
SQL statement "DELETE FROM ONLY "public"."daytype" WHERE "proj_id" = $1"

(The proj_id field of calendar table has a foreign key to proj_id of project
table.OS= Fedora Core 4.0)
Comment 1 Maurice van der Pot 2008-01-19 21:44:09 UTC 
This is a bug in postgresql and has been solved in version 8.2.5.