[OPEN-ILS-DEV] Database creation - trunk

Bill Ott bott at grpl.org
Mon Apr 14 14:48:01 EDT 2008


I believe I've come across a couple ordering issues with build-db.sh.  
Looks like some foreign keys are missing when these inserts are attempted.


psql:100.circ_matrix.sql:108: ERROR:  insert or update on table 
"circ_matrix_matchpoint" violates foreign key constraint 
"circ_matrix_matchpoint_org_unit_fkey"
DETAIL:  Key (org_unit)=(1) is not present in table "org_unit".


psql:300.schema.staged_search.sql:17: ERROR:  insert or update on table 
"relevance_adjustment" violates foreign key constraint 
"relevance_adjustment_field_fkey"
DETAIL:  Key (field)=(1) is not present in table "metabib_field".




More information about the Open-ils-dev mailing list